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
From: "Bastien Koert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
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 PROTE
thanks but it doesn't work =(
is it because i'm on MySQL version 3.23?
i have an error 1064 when running it...
hwee
- Original Message -
From: "Nandar" <[EMAIL PROTECTED]>
To: "Ng Hwee Hwee" <[EMAIL PROTECTED]>; "PHP DB List"
Sent: M
only versions 4.1 and above support subqueries...
bastien
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "PHP DB List"
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 all the employ
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"
Sent: Monday, September 19, 2005 9:14 AM
Subject: [PHP-DB] Subqu
