Query help re: type of join

[Access Beginner]

Hi All,

I have two queries, named Population and Debts.

I have been asked to give the Population for those that do not have a debt and I'm not sure how this would be done via Access.

When I go to create another query based on the queries above and I look at the 3 joins available, I can see how they would meet my needs.

The field that I use to join them both is called, Reference.

Cheers

 

[Norie]

It's a right join you want.

SELECT Population.PopName
FROM Debts RIGHT JOIN Population ON Debts.Reference = Population.Reference
WHERE Debts.Reference Is Null;

 

[Access Beginner]

It's a right join you want.

SELECT Population.PopName
FROM Debts RIGHT JOIN Population ON Debts.Reference = Population.Reference
WHERE Debts.Reference Is Null;

Thanks for that Norie, but what is PopName in the above?

Cheers

 

[Norie]

It's a made up fieldname, had to use one since you only supplied one field name.

Though I could just have returned Reference I suppose.

 

[Access Beginner]

thanks for that, I'll use Reference.

Cheers