Merge two tables into a third table

Question

I need to merge two tables imagem1 and imagem2 in a third table imagens with SQL. They have exactly the same structure but with 1 query I can’t write all the data at once, so I need to make 2 queries.

I need a SQL to merge the tables into a third call imagens. The starting point is shown in the image, I can do nothing different before that point.

The two tables have this structure ....

• ID
• IMMOVABLE
• CODE
• IMAGEM_G
• Imagem_p

In imagem1 does not have the data of IMAGEM_G while in imagem2 has not IMMOVABLE and CODE.

On the third call imagens I need all this information together.

Answer 1

Considering that the correspondence between the tables is by the ID column, I didn’t understand why I would need two queries. I would do so:

INSERT INTO imagens
(id, imovel, codigo, imagem_g, imagem_p)
SELECT 
    imagem1.id,
    imagem1.imovel,
    imagem1.codigo,
    imagem2.imagem_g,
    NULL -- Se tiver imagem_p em imagem2, coloque aqui
FROM imagem1
    INNER JOIN imagem2
    ON imagem2.id = imagem1.id

Answer 2

You can just update one of the tables as the example below, of course after updating its structure.

UPDATE docs 
 INNER JOIN docs_1 
   ON docs_1.id=docs.id
SET docs.teste2=docs_1.teste;