Mungkin bisa bantu walau sedikit; coba pakai : insert into table_A(col_1, col_2, col_3) select col_a, col_b, col_c from table_x, table_y, table_z where ...........;
atau bisa langsung : (dari belum ada table) create table Table_A as select col_a, col_b, col_c from table_x, table_y, table_z where ...........; maaf kalau salah..... ----- Original Message ----- From: david wahyudi To: [email protected] Sent: Wednesday, April 16, 2008 10:18 AM Subject: [indo-oracle] Query insert... ada yang pernah insert table kosong dgn hasil perintah join dari 3 tabel gak? jadi gini aku buat tabel kosong dan mau kumasukkin data. nah...datanya itu sama dengan hasil dari query join dari 3 tabel... ada yg tau sintaks sql-nya? __________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
