Re: [PHP-DB] Subquery

2005-09-18 Thread Nandar
i hope it's helping sql code: UPDATE T020Employee SET T020FaxNo = T010FaxNo FROM T020Employee a JOIN T010Company b ON a.T020CoCd =b.T010CoCd - Original Message - From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Sent: Monday, September 19, 2005 9:14 AM Subject:

RE: [PHP-DB] Subquery

2005-09-18 Thread Bastien Koert
only versions 4.1 and above support subqueries... bastien From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Subject: [PHP-DB] Subquery Date: Mon, 19 Sep 2005 10:14:34 +0800 hi, can some one enlighten me on what is wrong with my query? I want to set the fax number of

Re: [PHP-DB] Subquery

2005-09-18 Thread Ng Hwee Hwee
: Re: [PHP-DB] Subquery i hope it's helping sql code: UPDATE T020Employee SET T020FaxNo = T010FaxNo FROM T020Employee a JOIN T010Company b ON a.T020CoCd =b.T010CoCd - Original Message - From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Sent: Monday

Re: [PHP-DB] Subquery

2005-09-18 Thread Ng Hwee Hwee
: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Monday, September 19, 2005 11:30 AM Subject: RE: [PHP-DB] Subquery only versions 4.1 and above support subqueries... bastien From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Subject

RE: [PHP-DB] Subquery

2005-09-18 Thread Opec Kemp
It doesn't work because MySQL version 3.23.50 does not support sub-select statement. http://dev.mysql.com/doc/mysql/en/subqueries.html And How to re-write it in MySQL 4.1 http://dev.mysql.com/doc/mysql/en/rewriting-subqueries.html Nandar wrote on Monday, 19 September 2005 1:03 PM: i hope