>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

Thanks Sergey. I thought that was correct. Something else was causing issues with the result.