QUERY to display all row in two tables

[ElTech]

How can I display all rows for vendorkey even if vendorkey is null on table vendors


select vendor.name, vendor.key, vendor.id, item.number, item.name
from dbo.vendor, dbo.item
where vendor.key = item.vendorkey

With the query above I only get data that exists on table vednor

I want to get all of the lines on dbo.item even if it does not exist on dbo.vendor

 

[SQLDenis]

Use a left join

select v.name, v.key, v.id, i.number, i.name
from dbo.vendor v left join dbo.item i
on v.key = i.vendorkey

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/