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