Updating Multiple columns from subquery

r_ganesh76 · December 8th, 2004, 05:38 AM

Hi Experts,

Is it possible to do something like this??

Code:

UPDATE Table1
   SET Table1.Field1 = Table2.Field2,
   Table1.Field2 = Table3.Field2
From Table2
     Inner Join Table3
          On Table2.PK = Table3.PK
Where Table1.Key = Table2.Key

Hope you understand my problem.

Thanks in Advance

Regards
Ganesh

Rana · December 9th, 2004, 12:08 PM

Here is a Template that may help you

UPDATE Table1
SET Table1.Field1 = Table2.Field2,Table1.Field2 = Table3.Field2
FROM Table1 INNER JOIN Table2 ON Table1.Key = Table2.Key
INNER JOIN Table2 ON Table2.Key2 = Table3.Key2
WHERE Table1.Field=[Value] [AND/OR/*] Table2.Field =[Value]

This template is little flexible because you can use any kind of join you want if needed. Hope it helps.

r_ganesh76 · December 10th, 2004, 12:39 AM

Thanx Rana

Regards
Ganesh