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:[EMAIL PROTECTED]] Sent: sexta-feira, 5 de Abril de 2002 11:34 To: Sandeep Murphy Cc: [EMAIL PROTECTED] 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:[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
