List:General Discussion« Previous MessageNext Message »
From:Doug Beyer Date:January 15 2003 5:54pm
Subject:Confirmation of SELECT...IN syntax
View as plain text  
It's my understanding that embedded selects are NOT allowed in MySql. Is this correct?

Example:

SELECT t1.* 
FROM table1 t1 
WHERE ( t1.Id IN ( SELECT t2.Id FROM table2 t2 ) )



Doug Beyer
SAS Research and Development
503-617-7103 (Portland)
doug.beyer@stripped
SAS... The Power to Know

Thread
Confirmation of SELECT...IN syntaxDoug Beyer15 Jan
  • Re: Confirmation of SELECT...IN syntaxDan Nelson15 Jan
RE: Confirmation of SELECT...IN syntaxGeoffrey Hoffman15 Jan
  • Re: Confirmation of SELECT...IN syntaxJeremy Zawodny15 Jan
  • Re: Confirmation of SELECT...IN syntaxZak Greant16 Jan