Display data from two tables in query

garywood84

Registered User.
Local time
Today, 14:55
Joined
Apr 12, 2006
Messages
168
I have a database which contains details of groups of students. Groups are assigned tutor(s) using a link table between the Groups table and a Tutors Table.

I want to create a query which shows each group with their tutor. If I add the three tables to the query I can correctly generate a list of groups with their tutors, but any group which hasn't got a tutor (i.e. where the Tutor column would be blank) doesn't feature in the results.

I want all groups to be listed, even if they haven't got a tutor. Is this possible? How?!

Thanks in advance,

Gary
 
Last edited:
Think you right-click on the join and select 'all from <whatever>' to show the fields without a corresponding match in the other table.

Regards

Graham
 
Thanks Graham. I had looked at the join options, but didn't think, from the descriptions of them in the dialog box that they would do what I needed. I explored them a bit more after your post, though, and they did the trick!

Cheers,

Gary
 

Users who are viewing this thread

Back
Top Bottom