I tried something like this but it doesnt work. Thank you..
"SELECT table_1.id FROM table_1
CASE
WHEN (table_1.pid <> 0)
THEN LEFT JOIN table_2 ON table_1.pid = table_2.id
WHEN (table_1.nid <> 0)
THEN LEFT JOIN table_3 ON table_1.nid = table_3.id
END"
20
able_3 according to table_1. As a result,
it must be as below.
id title body
6 title6 body_text6
5 ntitle5 nbody_text5
What would be the query?
Thanks for your help.
--
Ali Deniz EREN
ali.deniz.e...@gmail.com
other way to do this. LIKE doesn't work because
"SELECT id, title, field1 FROM mesaj WHERE field1 LIKE 12" returns
many result which is not my intention.
Thank you.
--
Ali Deniz EREN
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysq
