SQL Query - Unmatched tables with a condition

[Journeyman3000]

Hi all.

I have two tables. One table has a basic list of items (Apples, Pears, Bananas, Oranges, etc). Lets call this tblFruit. This table looks like this.

ID | Fruit Name

The other table contain records of customer selections. A customer can select many different types of fruit. Lets call this tblPurchases. Table purchase looks like this

ID | Customer ID | Fruit Bought

I need a query that tells me what selections the customer hasn't made. The condition is that I can select any customer I want so that it would probably require the Customer ID

I tried using the unmatched wizard but didn't work. it keeps on showing me selections the customer did make, which is the complete opposite of what I need.

The reason I need this is so that I can make a combo box that shows choices left to make and does not display choices already made.

Any help appreciated.

Cheers

[Kyle123]

Like this maybe:

Please Login or Register  to view this content.

[Journeyman3000]

Thanks Kyle.

Unfortunately I keep getting a JOIN expression not supported error. It occurs on the 'AND sel.[Customer ID]=1 line.

I don't know how to fix that. Can you advise please.

Cheers

[Kyle123]

The SQL is fine, I think it may be an access syntax thing - I don't have it so I'll ask for some help

[:) Sixthsense :)]

Change the 1 to your Customer ID

[Journeyman3000]

Alright, thank you for your help!