Newbie : Updating a table from a query

[taoh15]

All

I have two tables

Table1 has three fields empid,elid, stats
Empid and Elid are unique
Table2 contains many values of empid,elid and apstatid

I need to do something like this
UPDATE Table1 SET Table1.stats= (SUM(Table2.apstatid)/COUNT(Table2.apstatid)) FROM
Table2 WHERE Table2.empid= Table1.empid AND Table2.elid= Table1.elid

How do I do it?

Thanks

[Delerna]

You nearly had it!

UPDATE Table1 
SET Table1.stats = 
(   SELECT SUM(Table2.apstatid)/COUNT(Table2.apstatid)
    FROM Table2 
    WHERE Table2.empid= Table1.empid 
         AND Table2.elid= Table1.elid 
)
 

[taoh15]

Thanks

That did it.

With a little help from Query Optimizer the 3.5hr operation not takes 3 secs :-)

Taoh