NOt supported... Yet. Rumor has it sub-selects will be in 4.1 John Morton wrote: > > 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
-- Bruce One day at a time... One second if that's what it takes --------------------------------------------------------------------- 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
