Can some assist me with an SQL query

[Chris100682]

Using a the left join function, how would I link the following tables

Table 1
src_prod_ofr
source_code

Table 2
Src_prod_ofr
CIT_code

[WoWo]

Really need to know what database it is but the ANSI standard would be......

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