OK, Im going to have to look more carefully at MYSQL, I think that when
there is no JOIN between the two tables "l.id_person" is evaluating to 0,
when I expected it to evaluate to NULL.
Let me do some more research!
Jason
-----Original Message-----
From: franky [mailto:[EMAIL PROTECTED]]
Sent: 06 July 2001 20:19
To: Jason Ward; LIste de Mysql
Subject: Re: conditional AND
I write this:
"Select p.name
>From tab_person p, tab_list l
Where l.id_tab_list = 18 And
l.id_person = 0 Or
l.id_person = p.id_person"
i will receve all name in person table!
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
François Boucher
[EMAIL PROTECTED]
_______
_ ( hello... )
Q _/\ ______/
<I>
¸L
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
