Mudah-mudahan ini solusinya : Update tableA as TABLE_A,tableB as TABLE_B set TABLE_A.a= TABLE_B.c Where TABLE_A.x = TABLE_B.y
field x dan y merupakan foreign key atau relasi antar kedua tabel. semoga membantu --- On Fri, 5/8/09, mei_litzx <[email protected]> wrote: From: mei_litzx <[email protected]> Subject: [indo-oracle] update data dari table a ke table b To: [email protected] Date: Friday, May 8, 2009, 5:33 AM hai rekans yang jago2 oraclenya mau minta bantuannya untuk kasus ini: (maaf pertanyaannya mungkin terlalu awam) saya mau update field a from tableA update dgn field c from tableB where x.tableA=y.tableB Trims in advance [Non-text portions of this message have been removed]
