Re: Confirmation of SELECT...IN syntax

[Dan Nelson]

In the last episode (Jan 15), Doug Beyer said:
> 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 ) )

Correct.  Your example can easily be converted to a join, though.

SELECT t1.* from table1 t1, table2 t2 where t1.id=t2.id

-- 
	Dan Nelson
	dnelson@stripped