nested Join

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a question about nested join.(I'm not sure that this is the right
name of this join)
I want to create the following querie.
I will give an example.
If i have one table Student with columns Name, Address, TelNumber
and one table Friends.And I want to extract wich student whith who is a
friend.
How i Can extract twice from the table Student the name, address and
telnumber for the firs student and the same information for his friend.
Is this possible in Microsoft Access 2003. And how I can do this ?

Tnank you in advance !
 
Join your tables as such (include the Student table twice):

Student - Friends - Student
where the first join is (StudentID = StudentID) and the second join is
(FriendID = StudentID) or something similar. I'm assuming that StudentID and
FriendID are actually from the same pool of IDs (e.g. PersonID).
 
Back
Top