Yes it's LEFT join.
>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
--sb--