var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Does mySQL support IN ( SELECT ... FROM )?
Does MySQL support the following syntax:
SELECT * FROM table1 WHERE table1_id IN ( SELECT table2_id FROM table2)
I tried someting like that in mysql and got syntax errors. What would be the correct syntax? I know in many cases I could use joins but just want to know.
mysql does not support subselects until version x
(where x is a number i don't know offhand -- and cannot
check because mysql.com seems to be down just now)
use a join
The following is a previous post in dbforums:
Last edited by rnealejr; 06-26-02 at 15:14.