Query with two tables

Question

I’m on a project, I have client table and work. A job has a client. I’ve already listed the tables, but I need to select that from the client id in the work table, return the client name.

I have to make a query to display in my php code.

Can someone please help me?

Answer 1

Supposing your tables are like this:

CLIENT int id, client name VARCHAR

WORK id int id_client int descr_work VARCHAR

You could do it like this:

SELECT a.id, a.descr_trabalho, b.nome_cliente from TRABALHO a 
    left join CLIENTE b on
       a.id_cliente = b.id