Hi, Can someone tell me why this will not work, please
SELECT * FROM tbl1 WHERE column =(SELECT * FROM tbl2 WHERE intcolumn = 15); (Table and column names changed to protect the innocent, "15" could be a variable or anything) I thought this was just a common or garden 'Inner Query'. I Have a feeling this has to do with the fact that I have to use different syntax for MySQL. I'm no SQL guru. Could someone please Point me in the right direction. Thanks in anticipation, john ++++++++++++++++++++++++++++++++++++++++++++ John Morton http://www.jdmorton.com Australia (08) 9451 6447 [EMAIL PROTECTED] Where is the wisdom we've lost in knowledge. Where is the knowledge we've lost in information?" -T.S. Eliot --------------------------------------------------------------------- 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
