Update query - urgent please help...v7

[zhelpmepleasez]

Please help
Trying to update a column in one table based on the contents column in another table
query is :


UPDATE "transaction" SET "RemainingBalance" = 0 WHERE ("transaction"."thebatch"= (SELECT "batches"."batch" FROM "batches"))

error is:
Invalid row-count in subquery.

 

[oradba101]

Hi, z

Is there only one record in the "batches" table that matches one record in the "tranaction" table?

William Chadbourne
Oracle DBA

 

[zhelpmepleasez]

no - the records in the "batches table are distinct
i.e. batch number
but in the main table the batch number may appear several times