List:General Discussion« Previous MessageNext Message »
From:Cal Evans Date:March 26 2001 2:02pm
Subject:RE: nested selects
View as plain text  
If you mean:
Select * from table where tableID in (Select tableID from table2);

Then no, MySQL does not support them.  They mythical version 4.0 might.  :)

Cal
http://www.calevans.com
 

-----Original Message-----
From: Philip Traynor [mailto:philip.traynor@stripped]
Sent: Monday, March 26, 2001 7:06 AM
To: 'mysql@stripped'
Subject: nested selects


Is mySQL able to perform nested selects?
If so can anyone provide me with an example
If not can you provide an alternate solution
Thanks
Philip



---------------------------------------------------------------------
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-thread69509@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cal=calevans.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
nested selectsPhilip Traynor26 Mar
  • RE: nested selectsCal Evans26 Mar
    • RE: nested selectsSinisa Milivojevic26 Mar
      • RE: nested selectsCal Evans26 Mar
        • RE: nested selectsSinisa Milivojevic26 Mar
          • Re: v4.0 feature listRyan Worley26 Mar
            • Re: v4.0 feature listSinisa Milivojevic27 Mar
RE: nested selectsalec.cawley27 Mar