>UPDATE t0 SET n1 = tm.n1m ; > FROM (lcCur) t0 JOIN ( ; > SELECT t1.m1, t1.m2, MAX(t1.n1 * t2.f1) AS n1m ; > FROM (lcCur) t1 JOIN Test2 t2 ON t2.Mx = t1.M1 OR t2.Mx = t1.M2 ; > GROUP BY 1,2 ; > ) tm ON tm.m1 = t0.m1 AND tm.m2 = t0.m2 > >>
>>lcCur = 'Test'
>>
>>>>lcCur = 'Test' >>UPDATE (lcCur) SET n1 = tm.n1m ; >> FROM (lcCur) inner JOIN ( ; >> SELECT t1.m1, t1.m2, MAX(t1.n1 * t2.f1) AS n1m ; >> FROM (lcCur) t1 inner JOIN Test2 t2 ON t2.Mx = t1.M1 OR t2.Mx = t1.M2 ; >> GROUP BY 1,2 ; >> ) tm ON tm.m1 = &lcCur..m1 AND tm.m2 = &lcCur..m2 >>>>