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...
ProgrammingStudent
Last Activity: Mar 5 '08, 10:04 PM
Joined: Feb 19 '08
Location:
-
Problems with select statement
-
TextBox - SelectAll() Problem
I have one text box where I enter a number. I can either click the calculate button or use the accept property (enter) to perform the calculation and display the answer in a label.
I use the SelectAll() method to select the number in the text box when it has the focus.
When I use the calculate button is works correctly but when I just hit enter the text box has the focus but the number is not selected.
... -
Thank you. It worked perfectly! -
SQL Help with two table
Here's the deal. I have two table but I want to include everything in table A that isn't in table B.
I have a list of product numbers in table A and I want to make a list of the one's in table B that haven't been used yet.
SELECT TableA.ProductN umer
FROM Table A Full Join TableB
ON TableA.ProductN umber <> TableB.ProductN umber
No activity results to display
Leave a comment: