Quote:
Originally Posted by ProgrammingStudent
I have 2 tables:
Customer Table
-CustomerID
-CustomerName
-CustomerState
Invoice Table
-InvoiceID
-CustomerID
I am having problems writing a select statement to find out which states have no customers in the invoice table...
Any ideas?
I have tried this:
select customerState
from customers
where customerID not in
(select customerID
from invoices)
It's usually a problem when you have NULLs somewhere. Try:
- select customerState
-
from customers
-
where customers.customerID not in (select isnull(invoices.customerID,'') from invoices)
Tell us what happen.
-- CK
