Confirmation of SELECT...IN syntax

2003-01-15 Thread Doug Beyer
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) [EMAIL PROTECTED] SAS... The Power to Know

Re: Confirmation of SELECT...IN syntax

2003-01-15 Thread 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,

RE: Confirmation of SELECT...IN syntax

2003-01-15 Thread Hoffman, Geoffrey
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:[EMAIL PROTECTED]] Sent: Wednesday, January

Re: Confirmation of SELECT...IN syntax

2003-01-15 Thread Jeremy Zawodny
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote: you are correct - subselects are NOT allowed until version 4 4.1 as opposed to 4.0.x. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51:

Re: Confirmation of SELECT...IN syntax

2003-01-15 Thread Zak Greant
On Wed, Jan 15, 2003 at 12:56:39PM -0700, Hoffman, Geoffrey wrote: you are correct - subselects are NOT allowed until version 4 Subselects will be available in version 4.1 -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications