RE: [PHP-WIN] update?'

hi, sorry for missing out on the database type.. am using Mysql 3.23... am trying to execute this query in query analyzer (Mascon) directly... -----Original Message----- From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@lumc.nl] Sent: sexta-feira, 5 de Abril de 2002 11:34 To: Sandeep Murphy Cc: php-windows@lists.php.net Subject: RE: [PHP-WIN] update?' 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:sandeep.murphy@oni.pt] > Sent: Thursday, April 04, 2002 1:31 PM > To: php-windows@lists.php.net > 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???