Hi
I'm suffering from sql blindness this this morning

If I have two tables and I want all the data from table1 and matching data from table2 is that not a left join ?

ie

select table1.data,table2.data from table1 left join table2 on table1.key = table2.key

is that right or wrong ?

Thanks