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" <php-db@lists.php.net>
Sent: Monday, September 19, 2005 11:02 AM
Subject: 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, September 19, 2005 9:14 AM
> Subject: [PHP-DB] Subquery
>
>
> hi,
>
> can some one enlighten me on what is wrong with my query?
>
> I want to set the fax number of all the employees of a particular
> company to
> the company's fax number. This is because the employees do not have
> personal
> fax machines, thus instead of just leaving T020FaxNo blank, I want to
> update
> it with the company's fax number. However, the following doesn't work?!
> i'm
> hoping i don't have to write a PHP while loop to do this simple task! =(
>
> UPDATE T020Employee SET T020FaxNo = (  SELECT T010FaxNo FROM T010Company
> WHERE  T010CoCd =  'XXX'  ) WHERE T020CoCd =  'XXX'
>
> MySQL version: 3.23.58. PHP version: 4.3.4.
> My database structure is:
> T010Company
> ===========
> T010CoCd (primary key)
> T010CoName
> T010Address
> T010TelNo
> T010FaxNo
>
> T020Employee
> ===========
> T020CoCd (primary key, linking to T010CoCd)
> T020EmpCd (primary key)
> T020JobTitle
> T020TelNo
> T020FaxNo
>
> Thanks so much!
> Hwee
>
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to