Selecting data when no record in the 'linked' table

[nekrecart]

How can I still select data when the specified record has no entry in the linked table?

Select *
FROM Employees e , Computers c
WHERE e.EmployeeID = c.EmployeeID

With this statement I will get all the employees that have a computer assigned to them. But I also want the employees without a computer in the list.

Example like this :
01 - JOHN - DELL 2400
02 - DARREN - HP PIV
03 - DAVID -
04 - BILL - DELL 2400

Thanks,

 

[JamesLean]

Look up OUTER JOINS in Books Online. Also get used to using ANSI join syntax rather than "old" way of using the WHERE clause:

SELECT *
FROM employees e LEFT JOIN computers c ON e.employeeid = c.employeeid

--James

 

[nekrecart]

Ha thanks it worked.

I was already wondering what that strange SQL notation was. I learned 2 new things today ;-)