UPDATE SUM FROM ANOTHER TABLE

[J BLAUSTEIN]

I am trying to update a column from another table sum without using a view -
I used:
update stmtbill set col1= (sum(ar)) from stmtbill t1, stmtdet t2 where t1.famno = t2.famno +
and invdate > (.#date -30)
any help would be appreciated
J

================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/