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

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 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, Janua

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,