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. tblCertificatio n1
a. VisitDate
b. CertificationSc ore1
3. tblCertificatio n2
a. VisitDate
b. CertificationSc ore2
Desired Result:
I want to list out each EmployeeID and add include the score from each
certification based on the VisitDate
EmployeeID | VisitDate | CertificationSc ore1 | CertificationSc ore2
1 | 02/02/05 | 50 | 50
If they didn't take Certification2 then leave it NULL
EmployeeID | VisitDate | CertificationSc ore1 | CertificationSc ore2
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.c om