July 10th, 2002, 04:03 PM
Join Date: Aug 2001
Location: over there
Time spent in forums: 46 m 57 sec
Reputation Power: 13
joining tables across mulitiple columns
If I have two tables (Members, Teams) with Teams having multiple foreign keys to the Members table how would go about selecting each team and getting the members names into the recordset as well. for example
--- Members --__----------- Teams ---------
And I wanna return from a query...
What combinations of joins, subqueries, etc would I have to use in order to get that result??? Thanks, rob
Last edited by rob5408 : July 10th, 2002 at 04:06 PM.