SELECT emp_last_name"Employee Last Name", dep_name"Dependent Name", CAST(dep_date_of_birth as char(12))"Dependent Date of Birth" from employee dependent ORDER BY emp_last_name;
I cannot figure out how to join it because there are so many dependents with the same last name. Any thoughts?
Discuss This Question: 2  Replies
I don't think using the last name is the way to go. There should be an emp id or similar.