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