On Fri, 6 Jul 2001, Mark G. Franz wrote:
> Here is my SQL;
>
> "SELECT Registration.CustomerID, Customer.CustomerID AS CustID, Firstname,
> Lastname, Username, Password, Question, Answer, Email, Age, Gender, Address,
> City, State, Zip FROM Customer, Registration WHERE Customer.CustomerID NOT
> LIKE Registration.CustomerID"
>
> I'm trying to return all the records from Customer that have not registered
> in Registration, so the psuedo sql would read;
>
> Return everything from all fields in Customer where the ID is NOT in the
> Registration table. Any ideas?
Maybe:
select ... from Customer where NOT EXISTS (Select * from
Registration where Customer.CustomerID LIKE Registration.CustomerID)