Grab data WHERE table.ID NOT LIKE otherTable.ID - Mailing list pgsql-general

From Mark G. Franz
Subject Grab data WHERE table.ID NOT LIKE otherTable.ID
Date
Msg-id 9i5dag$19ek$1@news.tht.net
Whole thread Raw
Responses Re: Grab data WHERE table.ID NOT LIKE otherTable.ID  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Naomi Walker
Date:
Subject: 2 gig file size limit
Next
From: robn@verdi.et.tudelft.nl (Rob van Nieuwkerk)
Date:
Subject: Re: Red Hat Database Development