First of all, it is useful to know _which_ database system you are using, in order to
give an answer, also weather the databases are
located within the same RDBMS or not.
And secondly your question is not related to php....
Anyhow, to start with the syntax of your update statement, it looks suspicious. The
UPDATE statement (according to ISO 9075) does
only take one(1) table name as a target table.
/Anders
> -----Original Message-----
> From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 04, 2002 1:31 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] update?'
>
>
>
> [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???
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
