Hi
I want to make query like this
Select p.name
from tab_person p, tab_list l
where l.id_tab_list = 18
if (l.id_person != 0){
AND l.id_person = p.id_person
}
table person
id_person,name,tel
table list
id_list,id_person,title
how can i do?
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
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