Hi everyone,
I have a quick question. If anyone could help me that would be great. I
have two tables in postgres.
table a
banid int4 primary key,
flags varchar(64)
table b
banid int4 foreign key
validate int4
What SQL statement would allow me to search for records in table a which
are not in table b. The additional constraint is that I only want records
from table a which do not have 'v' in the flags column.
Here's an example SQL statement I've been using but I'm thinking it is
flawed.
SELECT distinct a.banid FROM a,b WHERE a.banid != b.banid AND a.flags NOT
LIKE '%v%';
Any help would be most welcome!
Randy Jonasz
Software Engineer
Click2net Inc.
Web: http://www.click2net.com
Phone: (905) 271-3550
"You cannot possibly pay a philosopher what he's worth,
but try your best" -- Aristotle