Re: Sub query on mySQL 4.0.18

2004-06-04 Thread Prabu Subroto
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

Re: Sub query on mySQL 4.0.18

2004-06-02 Thread 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 quer

Re: Sub query on mySQL 4.0.18

2004-06-02 Thread Jigal van Hemert
> 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

Sub query on mySQL 4.0.18

2004-06-02 Thread Prabu Subroto
Dear my friends... I don#t understand why subquery on my MySQL 4.0.18-Mas does not valid. Here what I have done. " [EMAIL PROTECTED]:~> mysql -h 192.168.23.1 -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 354744 to server version:

RE: Query on Mysql

2001-11-01 Thread Chris Book
: Query on Mysql Hi ! I would like to use ASP(Active Server Pages) & Mysql as database for my website,can you please tell me the procedure for connecting the same. Pl reply ASAP. Regards, Murali __ Do You Yahoo!? Find a job, post your resume.

Query on Mysql

2001-11-01 Thread murali madhav
Hi ! I would like to use ASP(Active Server Pages) & Mysql as database for my website,can you please tell me the procedure for connecting the same. Pl reply ASAP. Regards, Murali __ Do You Yahoo!? Find a job, post your resume. http://careers.yah