General information
Forum:
Microsoft SQL Server
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only