SQL query advice

[Chris100682]

Hi,
I asked for help from you guys with an SQL query yesterday and someone replied and helped really helped me, I was given the following query

select T1.src_prod_ofr, T1. source_code, T2.cit_code
FROM table1 T1
LEFT JOIN table2 T2
ON T1.src_prod_ofr = T2.src_prod_ofr

Question: If I wanted to add another table to the query how would I go about doing this? How would I write the query?

[OBonio]

Add it as another JOIN. Say Table3 is the name of the 3rd table. For instance :

SELECT T1.src_prod_ofr, T1. source_code, T2.cit_code
FROM Table1 T1
LEFT JOIN Table2 T2
ON T1.src_prod_ofr = T2.src_prod_ofr
JOIN Table3 T3
ON T2.cit_code = T3.cit_code

This would only return rows where Table3's cit_code is the same as Table2's cit_code. To return all records, do another LEFT JOIN instead of the normal JOIN.

[OBonio]

Oh, and then you can add T3.<column_name> to the SELECT clause of the statement to get info from Table3.

[Chris100682]

Obonio your are a life saver!

[OBonio]

No problem.