List:General Discussion« Previous MessageNext Message »
From:Bruce Ferrell Date:November 10 2001 5:31pm
Subject:Re: Beginner SQL Question
View as plain text  
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
Thread
Beginner SQL QuestionJohn Morton10 Nov
  • Re: Beginner SQL QuestionCarl Troein10 Nov
  • Re: Beginner SQL QuestionSteve Meyers10 Nov
  • Re: Beginner SQL QuestionBruce Ferrell10 Nov
  • Re: Beginner SQL QuestionShankar Unni10 Nov
  • Re: Beginner SQL QuestionNguyen Trong Phuc10 Nov
  • Re: Beginner SQL QuestionNguyen Trong Phuc10 Nov
  • Re: Beginner SQL QuestionShankar Unni10 Nov
  • Re: Beginner SQL QuestionNguyen Trong Phuc10 Nov