Hi all , i have a doubt wich query performs better
Update table a set field1=b.field 1
From (select field1,field2
From table2 where x=z
) b
Where a.field2=b.field2
Or
Create temp table y as
select field1,field2
From table2 where x=z;
Update table a
set field1=b.field1
From y as b
Where a.field2=b.field2
I ve been told not to use subquerys, but i think this refers to
Select * from table where field1 in (select field1 from table2)
Any thoughts?
Thanks people y'all