help with select statement.

[cb49747]

I'm not sure how to do this and was hoping for some help here.

I have a transaction table, wich has multiple transactions for one customer. each transaction has type. I want to find all customers who do not have a particular type of transaction.

The problem I have is it seems to find a postive result for every customer because every customer has a least one transaction that is not of this type. and I want the ones who have never had a transaction of this type.

Not sure if that makes sense.

anyway, appreciate any help.

 

[rac2]

This query lists all of the customers with transactions of the particular type.

SELECT DISTINCT customer_id
FROM Transactions
WHERE Transactions.type = 'particular type'

So the ones you are looking for are not in that list.

SELECT * FROM Customers
WHERE customer_id NOT IN (
    SELECT DISTINCT customer_id
    FROM Transactions
    WHERE Transactions.type = 'particular type'
   )

 

[cb49747]

Worked great thanks.