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

>Okay, this one works fine. Thank you.
>
>Now the tricky part
>
>test is not directly availabel
>
>All i now is a var just like
>

>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
>

>
>will not work.
>