Display data from two tables in query

[garywood84]

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

 

[grahamjlaws]

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

 

[garywood84]

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