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
2009/2/24 Ali Deniz EREN ali.deniz.e
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
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.mysql.com/mysql
To unsubscribe:http