Grab data WHERE table.ID NOT LIKE otherTable.ID

From: "Mark G(dot) Franz" <mgfranz(at)pe(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Grab data WHERE table.ID NOT LIKE otherTable.ID
Date: 2001-07-06 22:14:30
Message-ID: 9i5dag$19ek$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Naomi Walker 2001-07-06 22:51:44 2 gig file size limit
Previous Message Bruce Momjian 2001-07-06 21:59:46 Re: [GENERAL] Vacuum and Transactions