UPDATE using multiple tables

From: jmpXor <blaine_at_usa-brasil.com>
Date: 22 Apr 2005 13:31:10 -0700
Message-ID: <1114201869.964801.225160@f14g2000cwb.googlegroups.com>

I have two tables table A and table B I want to get the audit_date from table b into the field date_reported on table A where the values in the field skey_ref on table B match the field skey on table A.

I have tried using this statement but have no luck. Any help would be greatly appreciated.

update tableA set date_reported = (select audit_date from tableB, tableA
where tableB.skey_ref = tableA.skey)

Returns: ORA-01427: single-row subquery returns more than one row Received on Fri Apr 22 2005 - 15:31:10 CDT