From: Bruce Ferrell
Date: November 10 2001 5:31pm
Subject: Re: Beginner SQL Question
List-Archive: http://lists.mysql.com/mysql/90833
Message-Id: <3BED6468.9015A7FA@baywinds.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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