List:General Discussion« Previous MessageNext Message »
From:Geoffrey Hoffman Date:January 15 2003 7:56pm
Subject:RE: Confirmation of SELECT...IN syntax
View as plain text  
you are correct - subselects are NOT allowed until version 4

until then:

 SELECT t1.* 
 FROM table1 t1 
 LEFT JOIN t2 ON t1.id = t2.id

OR 

 SELECT t1.* 
 FROM table1 t1 
 LEFT JOIN t2 USING (id)

> -----Original Message-----
> From: Doug Beyer [mailto:Doug.Beyer@stripped]
> Sent: Wednesday, January 15, 2003 10:55 AM
> 
> 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 ) )

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