Just a lack of knowledge on SQL.
(+.+)(-.-)(_ _)
Agnes
>Hi Agnes,
>
>You're welcome. What other problems do you still have with it?
>
>>
>>thank you very much. Looks I like I need to update myself. The form UPDATE Alias SET .. FROM .. AS ALias seems to solve some of my problems
>>
>>Agnes
>>
>>>
>>>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
>>>
>>>
>>>
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]