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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete all one side records with no many side records 4
C# Skype silent connection 0
cross tab query outer join 1
Query from two related tables 4
Syntax for nested joins on 3 tables 2
How to finding student Rank and How to upload bulk marks of each student at a time. 1
Help! Need to update linked SQL table in Acc07 3
If statement in Update query 7

Back
Top