Oooo...Oo. thank you very much for you
information.
I better migrate my database to postgres.
I'll use MySQL back after MySQL 4.1 stable version
released on SuSE Distro.
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > I don#t understand why subquery on my MySQL
> 4.0.18-Mas
> > does not v
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 quer
> I don#t understand why subquery on my MySQL 4.0.18-Mas
> does not valid.
Simple reason: v. 4.0.18 does not support subqueries yet. Use 4.1 or later.
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
