SQL sub query Help

[vzjfgm]

I am working on a query that links two tables. Table 'A' is a list of employees. Table 'B' is a list of employees with safety visits. I want to create one query with all employees and any safety visits YTD. My issue is when I select the Safety visits for Year 2009. I get only the employees that had visits in 2009. I need all employees even if did not have a safety visit. How can I do this in SQL with out multiple queries?

Thank you very much!!!

 

[PHV]

Use a LEFT JOIN ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886