SQL Update Statement on two tables - Xtreme Visual Basic Talk

04-26-2008, 04:30 AM

eByong

Regular

Join Date: Sep 2005

Location: Cebu Phillippines

Posts: 62

SQL Update Statement on two tables

hi guys im having trouble updating my two tables: nTest1 and nTest2
is it possible with sql? pls help... thanks

i want to update the emp_name column on nTest1 where the value is in nTest2 column emp_name base on emp_id...

the output basically overwrite the nTest1 emp_name column from nTest2 emp_name column base on the emp_id which is unique..

i have attached here a screenshot for details

Attached Images

sql1.JPG (57.2 KB, 12 views)

__________________
________________________________________

- Don't cry bcoz its over, Smile bcoz it happens...

04-26-2008, 05:42 AM

PeetSoft

Centurion

Join Date: Jun 2003

Location: HHW - the Netherlands

Posts: 161

As I read it, you'll only have to update nTest1 as you're only reading from nTest2.

__________________
-----------------------------------------------------
If debugging is the art of removing bugs, then
programming must be the art of inserting them.
----------------------------------------------------- I do comply with Flyguy's signature

04-27-2008, 06:35 PM

eByong

Regular

Join Date: Sep 2005

Location: Cebu Phillippines

Posts: 62

sorry my bad yes the ntest1 emp_name column should be the only table to be updated how should i code it...my existing code does not work

Code:

UPDATE nTest1 
   SET emp_name = nTest2.emp_name
   FROM (SELECT emp_name FROM nTest2 WHERE nTest1.emp_id = nTest2.emp_id)

__________________
________________________________________

- Don't cry bcoz its over, Smile bcoz it happens...

Last edited by eByong; 04-27-2008 at 06:38 PM. Reason: no codes tag

04-28-2008, 01:33 AM

TRANSLTR

Centurion

Join Date: Aug 2005

Location: UK

Posts: 153

You're not too far off:

update ntest1 set emp_name =
(select emp_name from ntest2 where ntest1.emp_id = ntest2.emp_id)

J

__________________
Leveraging synergies to deliver outstanding customer value. And all that stuff.