simple query

  • Thread starter Thread starter sergiogroups
  • Start date Start date
S

sergiogroups

If It have a table T_Contacts:

Name Gender FamilyID
John M 1
Paul M 2
Anna F 1
Kate F 2

And want to create a table T_Couples:

Husband Wife
John Anna
Paul Kate

which is the query to do that?
 
If It have a table T_Contacts:

Name Gender FamilyID
John M 1
Paul M 2
Anna F 1
Kate F 2

And want to create a table T_Couples:

Husband Wife
John Anna
Paul Kate

which is the query to do that?
Click to expand...

I am not sure you want a new table. You have a table with the
individuals, all you need do is to provide the relationships to the existing
people you already have.

I believe there is an example of this kind of join in the Northwind
example that comes with Access.
 
Back
Top