UPDATE Test SET n1 = Test.n1 * tm.f1m ;
FROM Test JOIN ( ;
SELECT t21.mx AS m1, t22.Mx AS m2, IIF(t21.f1 > t22.f1, t21.f1, t22.f1) AS f1m ;
FROM Test2 t21, Test2 t22 ;
) tm ON tm.m1 = Test.m1 AND tm.m2 = Test.m2
> >again, I have a SQL Problem. This time it's an UPDATE: > >given < snip >