Conversion of updates in Access to SQL Server

[Loretta Manuel]

Hi,

I have 2 questions :
1) How do I update the columns of a table that isjoined with other tables.

Eg in MS Access:

update table1 inner join (Table 2 inner joinTable 3 on Table 2.col1=table3.col1) on table1.col2=table3.col2 set table2.col3='xxx'

How do I convert this in SQL Server?

2) Update table1 inner join (Table2 innner join table3 on Table 2.col1=table3.col1) on table1.col2=table3.col2 set table1.col3='xxx', table2.col3='yyy', table3.col3=table2.col3

How do I convert this in SQL Server?

Please help !!!

[iburyak]

Try this:

update table2
set col3='xxx'
from table2 
inner join Table3 on Table2.col1 = table3.col1
inner join Table1 on table1.col2 = table3.col2 

Good Luck.