[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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php