>"INSERT INTO RECON (field1, field2, field3)
>
>SELECT fieldA, fieldB, SUM(FieldC)
>FROM Table2
>WHERE fieldA = 'xyz'
>GROUP BY fieldA, fieldB
>
>WHERE Table2.BATCHNO = RECON.BATCHNO"
>
>??? Anyone got any idea of how I can do this?

Sorry - I meant

"UPDATE RECON
SET
field1 = (SELECT BATCHNO, SUM(fieldA) FROM Table2
GROUP BY BATCHNO)
WHERE
RECON.BATCHNO = Table2.BATCHNO"



[Non-text portions of this message have been removed]