Question Looking for a sql for relational database

[mahmood]

Hi Guys

I am looking for a sql statement for an Access database with these three tables:

1. Customer(Cus_ID, Cus_Name)
2. Customer_Item (Cus_ID, Item_ID)
3. Item (Item_ID, ItemName)

What I want is to find all the records from Customer and Item
WHERE Customer.Cus_ID <> Customer_Item.Cus_ID AND Item.Item_ID <> Customer_Item.Item_ID

Another word, I want to get a list of customers and items that the items haven't been sold to the customers.

By the way, this is only an example so I can explain my problem better.

Thanks in advance.