RE: Confirmation of SELECT...IN syntax

[Geoffrey Hoffman]

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 ) )