Handling multiple values in subquery
I have two tables one of which holds employee information and the other
that holds dependents information. I want to create a query which
retrieves all the first names of each employees children and combine them
into one field of the results.
I know how to create a subquery that returns a single result as a field in
another query but not having any luck figuring this one out. Any
suggestions would be greatly appreciated.
Tables: tblPersonnel, tblFamilyData linked by [ID] primary [sponsorID]
foriegn
Desired output: EmployeeName | Address | KidName1, KidName2, KidName3
No comments:
Post a Comment