Code:
UPDATE tabela1 t1 set (t1.polje1,t1.polje2)=(select t2.vr,t2.vr2 from tabela2 t2)
UPDATE tabela1 t1 set (t1.polje1,t1.polje2)=(select t2.vr,t2.vr2 from tabela2 t2)
da ne moram stavljati za svako polje = ...tako bih morao za svaki entitet odradit po jedan select jer se radi o grupiranoj tabeli2
Give me six hours to chop down a tree and I will spend the first four sharpening the axe.