Update query [modified]

[micydon]

Pls anybody help me. i hve to update a feild( say rcvd) in receivables table from taking the feild(amount) from allocation table. i give the query like this" update receivables,allocation set rcvd=rcvd+amount where receivables.no=allocation.no " i want to know whether we can give 2 table name in update query if so then the syntax when i give the above i am getting error.pls help me its urgent -- modified at 4:31 Saturday 20th January, 2007

[Bassam Saoud]

Hope this [^] helps..

[M H 1 2 3]

try ... update r set rcvd = r.rcvd + a.amount from receivables r join allocation a on a.no = r.no