Re: Sub query on mySQL 4.0.18

[Michael Stassen]

Jigal van Hemert wrote:

I don#t understand why subquery on my MySQL 4.0.18-Mas
does not valid.
select * from salesreport where custid in
(select custid from appointment where done='N');

Simple reason: v. 4.0.18 does not support subqueries yet. Use 4.1 or later.

Regards, Jigal.

Or, rewrite the query as a join.

  SELECT * FROM salesreport s, appointment a
  WHERE s.custid = a.custid AND a.done = 'N';

See <http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html>.

Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]