Thank you for taking the time to look at my question. Any help would
be much appreciated !
Database:
Microsoft SQL Server 2000
Database Structure:
1. tblEmployee
a. EmployeeID
2. tblCertification1
a. VisitDate
b. CertificationScore1
3. tblCertification2
a. VisitDate
b. CertificationScore2
Desired Result:
I want to list out each EmployeeID and add include the score from each
certification based on the VisitDate
EmployeeID | VisitDate | CertificationScore1 | CertificationScore2
1 | 02/02/05 | 50 | 50
If they didn't take Certification2 then leave it NULL
EmployeeID | VisitDate | CertificationScore1 | CertificationScore2
1 | 02/02/05 | 50 | <NULL>
Question:
I'm having difficulty linking the tables together and appending the
fields to the right of the EmployeeID based on their VisitDate. Any
ideas ?
Thank you so much !
cw*****@gmail.com