This is my mssql syntax :
update t1
set v = 0
from t1 table1
left outer join t2 table2
on table1.id = table2.id
left outer join t3 table3
on table2.id = table3.id
left outer join t4 table4
on table3.id = table4.id
where table1.id = 2;
This is in Snowflake
update t1
set v = 0
from t1 table1
left outer join t2 table2
on table1.id = table2.id
left outer join t3 table3
on table2.id = table3.id
left outer join t4 table4
on table3.id = table4.id
where table1.id = 2;
But mssql returns 1 row, snowflake returns 5. Is there any other way to get 1 row in snowflake.
1