Buat semua yang ngasih jawaban, saya ucapkan terima kasih.... Sekarang masalahnya dach Beres....
Thx ya....ntar k'lo ada masalah lagi, boleh donk nanya... :D Pada tanggal 6/28/06, abbas <[EMAIL PROTECTED]> menulis: > > Saya pernah coba tuh mas, dan bisa, maksudnya isi table A di tambah isi > table B kan? mungkin caranya seperti ini: > > insert into TB_B.dbo.Table_XYZ (Value1, Value2, Value3) > select TB_A.dbo.Table_XYZ.Value1, > TB_A.dbo.Table_XYZ.Value2, > TB_A.dbo.Table_XYZ.Value3 > from TB_A.dbo.Table_XYZ where TB_A.dbo.Table_XYZ.Value1 not in (select > Value1 from TB_B.dbo.Table_XYZ) > > CMIIW. > > ----- Original Message ----- > From: rh4gh13lz > To: itcenter@yahoogroups.com <itcenter%40yahoogroups.com> > Sent: Tuesday, June 27, 2006 4:09 PM > Subject: [ITCENTER] Gabung value 2 table (yg sama) dr 2 db yg beda / SQL > > Maaf mas2x n mbak2x senior mo nanya dikit nich soal SQL server. > bisa ga' gabungin value 2 table (yg sama) dr 2 db yg beda. > > Thx buat jawabannya.... > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/