Last post Oct 25, 2011 08:23 AM by Mamba Dai - MSFT
Oct 20, 2011 08:39 PM|lpieczynski|LINK
I've been trying to figure out an "easy" way to create a mailing list of my students with the usual lastname, firstname, address, city, state, etc. This all works fine - except that I'm getting multiple records for the same family when they have more than
one children in our database. So, ideally, I would like to be able to group by the family name (which is grouped in a seperate Family table then linked to the student table by familyid), then in the second field list each child of that family separated by
a comma. I just thought I'd check to see if anyone out there has already done it and is willing share. I have to believe this is a common scenario.
Thanks in advance! - Lana
Oct 25, 2011 08:23 AM|Mamba Dai - MSFT|LINK
Your information indicates you need to redesign your structure of tables and use join query, and you aslo mentioned how to redesign the tables. Therefore, the key point how to use join query to retrieve the records, please check this reference about join
By the way, if you can post your problem to this:
You will recieve more professional and exact idea for your issue.