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
> john@stripped
>
> 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 <mysql-thread90824@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-bferrell=baywinds.org@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Bruce
One day at a time... One second if that's what it takes
