I have the tables:
+----------Tabela-1--------+
id | nome | cnpj | qtd1
1 | carlos | 0563233 | 4
+--------------------------+
+----------Tabela-2--------+
id | nome | cnpj | qtd2
1 | carlos | 0563233 | 6
+--------------------------+
+----------Tabela-3--------+
id | nome | cnpj | qtd3
1 | carlos | 0563233 | 8
+--------------------------+
I would like to make a sql command to generate a single table by putting the different named columns side by side, for example:
+------------------------------------------------------------------+
id | nome | cnpj | qtd1 | qtd2 | qtd3
1 | carlos | 0563233 | 4 | 6 | 8
+------------------------------------------------------------------+
Can anyone help me please?