update?'
| From: | Sandeep Murphy | Date: | Thu, 04 Apr 2002 11:31:08 +0000 |
| Subject: | update?' | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-12927@lists.php.net to get a copy of this message | ||
[Sandeep Murphy]
Hi,
I need to update an entire table in one database with the values from
another database... My query reads like this:
update palmeira.t_colaboradores t, hr.member_status s, hr.member_data d
set t.structure=s.structure, t.depart_area=s.area where t.cs_id=d.cs_id
and d.cs_id=125
[Sandeep Murphy]
in the query, plameira and hr are the 2 diff databases....
any suggestions as to how to make this work???
tia,
sands