Kalau hanya nampilkan data saja pakai UNION, kalau update data pakai
pipeline dg pilihan Insert/Update
Regards,
Nurhamid Abdulbasith
PT Avon Indonesia
Cilandak Commercial Estate Building 208
Jl .Cilandak KKO , Jakarta Selatan
Phone : (62-21) 7801200 Ext. 6313
"Pemula PB" <[EMAIL PROTECTED]>
01/04/2005 10:22 AM
Please respond to indopb
To: [email protected]
cc:
Subject: [indopb] Gimana SQL Statementnya ?
Salam rekan IndoPB,
Mohon masukan gimana statemen SQL nya untuk menggabungkan
data dari 2 Tabel.
Misalkan ada ada 2 tabel yakni tbl_AA dan tbl_XX
data di tbl_AA
ID NamaBarang Quantity
101 HardDisk 45
102 Keyboard 18
103 Mouse 22
104 Monitor 7
105 PC Casing 5
106 FlashDisk 28
data di tbl_XX
ID NamaBarang Quantity
101 HardDisk 45
102 Keyboard 18
103 Mouse 22
104 Monitor 7
Data yang ada di tabel tbl_AA akan digabung ke tbl_XX
dengan mengecek apakah data tersebut sudah pernah ada.
Kalau sudah pernah ada maka data tersebut diUpdate, kalau
belum maka data ditambahkan.
Mohon pencerahan
Salam
PemulaPB
========================================================================================
Akses Internet TELKOMNet-Instan beri Diskon s.d. 50 % khusus untuk wilayah
Jawa Timur.
Informasi selengkapnya di www.telkomnetinstan.com atau hub 0800-1-INSTAN
(467826)
========================================================================================
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
[Non-text portions of this message have been removed]
-----------------------------------------------
INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT
-----------------------------------------------
IndoPB - Indonesia PB User Group
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> 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/
