Re: [PHP] An small SQL problem

Hi Brad, Oooops. I think i better go and read your excelent book MySQL/PHP database applications agian.. Best regards, Davy Obdam mailto:[EMAIL PROTECTED] Brad Bulger wrote: >what database are you using? because the answer is different, depending. > >on postgres, for example, which suppo

[PHP] An small SQL problem

Hello, I'm probably sleepy because I can't do a very easy query. :( I have 2 tables TableA(FieldA1, FieldA2, FieldA3) and TableB(FieldB1, FieldB2, FieldB3). I'd like to see the TableA records (FieldA2) where the FieldA1(Primary key) not exist in TableB(FieldB2). I tried "not exists" without suc

Re: [PHP] An small SQL problem

what database are you using? because the answer is different, depending. on postgres, for example, which supports subselects, you can do select * from TableA where FieldA1 not in (select FieldB2 from TableB) with mysql, there are no subselects, so you'd have to do something like select TableA

Re: [PHP] An small SQL problem

Hi Christian, I am not 100% sure cos i am doing this from my head but your SELECT query would have to look like this: SELECT TableA.FieldA2 FROM TableA, TableB WHERE TableA.FieldA1 != TableB.FieldB2 btw. Wouldn`t be easier to use more informative Table and Field names..? Hope it works, Best