table join 1

[bevan]

I want to join a user table (M list) to a payment table (pay) via the user ID. HOwever, Access wants to only display those users who DID make a payment and I want all users displayed even if they didn't make a payment.

Current query is

SELECT [M List].*, Pay.P_AMOUNT
FROM [M List] INNER JOIN Pay ON [M List].USERID = Pay.USERID;

How can I make the query display all the records and payment information for those people who have payed?

Bevan

 

[apbamike]

Use something like this

SELECT AAJOB.EEOC_CD
FROM AAJOB LEFT JOIN AARATE ON AAJOB.CLASS_CD = AARATE.CLASS_CD;