Re: Q: SQL query problems

2001-05-22 Thread Wemmer Alexander
left join b using (eid) > where b.gid = and b.eid is null No, i already tried this before and it always gives back an empty set :( When you skip the "and b.eid is null" clause you will see, that this statement exactly selects all entries from a which ARE referenced from b. -- gree

Q: SQL query problems

2001-05-22 Thread Wemmer Alexander
one sql-statement? - I have tried over and over, but didn't get a correct sollution. One of my tries was: select a.eid from a,b where b.gid = and a.eid != b.eid but it didn't work out. Any help is welcome! THX -- greetings - WEMMER Alexander <[EMAIL PROTECTED]> T