>Hello,
>I'm been trying to get the apperach correct so let me expalin the problem.
>
>In table A, I have employee data and a key field. I table B I have the same keyfield, project name and other numbers.
>What I want to pull out are not only the data where a.Keyfield = B.keyfield but all the projects that the employee has no data whatsoever thus giving a complete picture. The cursor whould have data like this
>
>1001 project1 10 Here there is actual data
>1001 project2 5
>1001 project3 0 Here there is no data
>
>HOw do I SQL this info out??
>
>Thanks,
>
>Sandy
Left Join may help in this case:
Select * ;
From Projects A Left Join Employee B on A.EmployeeID=B.EmployeeID ;
Into Cursor crsTemp Nofilter
Igor Gelin
Database Developer