Relatedd and two tables

Question

Guys, I have two tables and I need to connect them. I’m doing it this way:

SELECT lancamentos .* FROM lancamentos
  INNER JOIN clientes ON lancamentos.cliente_id = clientes.id
  ORDER BY clientes.nome ASC

But I need to bring the name of the company that is in the client table ... I’m having a hard time with this ...

Answer 1

In the example below, I created a alias for each table.

SELECT l.*, c.* 
FROM lancamentos as l
JOIN clientes as c ON c.id = l.cliente_id
ORDER BY c.nome ASC

It is not good practice to use asterisks, so replace with the name of the fields you are using.

example: c.nome_empresa, c.empresa_tel