Questions tagged as 'join'

2
answers

Select empty data

My code returns all users, verifying that they have paid the last month, however I connect two tables, one of all the clients with the registered payment table, I want it to print in jTable even if it does not have left join seems...
asked by 27.04.2016 / 18:21
0
answers

INNER JOIN returning error

I'm trying an INNER JOIN between 3 tables plus error returns, I do not know what's wrong. Query: SELECT aa.arq_arqid, aa.arq_nome, aa.arq_nomecrip, aa.arq_datetime, u_usuarios_u_userid a_area_a_areaid FROM arq_arquiv...
asked by 18.03.2016 / 03:18
1
answer

How to make a SQL do the correct count of real estate under certain criteria

I have the following SQL that correctly counts the number of properties: select clientes.id, clientes.nome, clientes.status, clientes.cliente, clientes.tipo, clientes.disponibilidade, imoveis.id, imoveis.cod, imoveis.status, imoveis.vvenda,...
asked by 16.03.2016 / 12:41
2
answers

Join does not return as expected

I have the following scheme: tblpessoa with the fields: idPerson, name. tag with the fields: idCity, codCity, name, idPerformance (fk of the tblpessoa table), codeRegionCity (fk of the tblregiaoCity table). tblregiaoCity with the...
asked by 14.10.2015 / 14:50
4
answers

What is the difference between INNER JOIN and OUTER JOIN?

What is the difference between INNER JOIN and OUTER JOIN ? Can you give me some examples?     
asked by 19.02.2014 / 03:32
0
answers

Inner Join + Where in MySQL

How to use INNER JOIN with WHERE ? I'm doing a INNER JOIN with 3 tables. I need a WHERE to return only one record. I'm trying this way: SELECT '*' FROM ('tabela1') INNER JOIN 'tabela2' ON 'tabela1'.'id' = 'tabela...
asked by 27.05.2015 / 20:09
2
answers

Query assembly query with INNER JOIN

Hello ... I have the following query: $conexao = connect(); $consulta3 = mysql_query("SELECT meu.id, f.idfollowed, eu_sigo.fname, eu_sigo.id, eu_sigo.profile, eu_sigo.photoperf, p.id, p.title, p.link, p.description, p.descr, p.url, p.photo...
asked by 29.12.2014 / 19:46
2
answers

inner join mysql 2 tables

Good night guys, I need to link two tables and I can not fix it or find where I'm going wrong. I have two tables: Table 1: br_regiao | id - iduf - name - (1, 1, Litoral) Table 2: br_stat | id - name - (1 - Santa Catarina) Query: nam...
asked by 21.10.2017 / 04:19
1
answer

SQL database structure of a bookstore [closed]

I need to write and populate a MySQL database on controlling a bookstore. This involves: 3 tables: | publisher | book | author | The 'publisher' table should have: id, name, city, state, country. The 'book' table should have: ISBN, name, y...
asked by 17.10.2016 / 02:53
0
answers

Using Join to save data in a MYSQL table [duplicate]

Hello, I would like to know if I have save data that I select from two tables and save to another through the join, because through a trigger it is not possible to do and until then I only used the join to perform views but I believe that give...
asked by 31.12.2018 / 02:16