Hi,

Can anyone help me turn this into a left join?

I want to get all of the records from the directors table whether matches exist 
in the members table or not.

SELECT d.directorid, d.fname, d.mname, d.lname, d.title, d.suffix, d.active, 
d.function, 
m.id, m.directorid, m.committee, m.position, m.year FROM directors as d, 
members as m 
WHERE d.directorid = m.directorid 
AND m.year = '2006'
ORDER BY d.lname, d.mname, d.fname; 

Thank you for your help...


Keith

Reply via email to