Questions tagged as 'join'

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,...

Hello, is it possible to use INNER JOIN together with INSERT ? I have a table A with 3 columns X, Y and Z and table B with columns W, X and Y and I need to insert table W in table A, column W? I'm trying this way but I get no res...

I have an INNER JOIN that is duplicating records in the view. Because in the database such records are not duplicates. select conta.dominio, conta.id, conta.modelo, imoveis.id, imoveis.cod, imoveis.titulo, imoveis.vvenda, imoveis.vtem...