"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?
>
> Thanks,
>
> Mark
Try the NOT EXISTS operator:
SELECT Customer.CustomerID AS CustID, Firstname, Lastname, Username,
Password, Question, Answer, Email, Age, Gender, Address, City, State,
Zip
FROM Customer
WHERE Customer.CustomerID
NOT EXISTS (SELECT *
FROM Registration
WHERE Registration.CustomerID = Customer.CustomerID);
Hope this helps,
Nils Zonneveld
--
Alles van waarde is weerloos
Lucebert
