An small SQL problem
| From: | Christian Ista | Date: | Sat, 12 Oct 2002 08:04:13 +0000 |
| Subject: | An small SQL problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-119724@lists.php.net to get a copy of this message | ||
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 success.
Could you help me ?
Christian,