Re: [Programmer-VB] join 2 table masing2 3 record

[Eko]

Tabel A select No_PPB,Barang,QTY,QTY_ORDER,KET from jppbd where No_PPB like '0004/PPB/032006' No_PPB                   Barang            QTY    QTY_ORDER   KET 0004/PPB/032006     BL/MAR/012       1               1            0004/PPB/032006                                                            (OSCAR FABRIC) 0004/PPB/032006                                                             WARNA HITAM   Tabel B select No_PO,No_PPB,KD_BRG,QTY,QTYT,Ket from jpod where No_PPB like '0004/PPB/032006' No_PO                    No_PPB                   KD_BRG          QTY     QTYT           Ket 0330/ADM/032006   0004/PPB/032006     BL/MAR/012       1               1            0330/ADM/032006   0004/PPB/032006                                                            (OSCAR FABRIC) 0330/ADM/032006   0004/PPB/032006                                                             WARNA HITAM   yang diinginkan kedua tabel itu di join dg jumlah record tetap 3, sebab saya pingin nge-cek perbandingan quantitynya   ----- Original Message ----- From: Ronald Irawan To: Programmer-VB@yahoogroups.com Sent: Wednesday, May 31, 2006 9:26 AM Subject: Re: [Programmer-VB] join 2 table masing2 3 record tabel a dan table b ada relasi nya gak ? kalau ada dan datanya ada yg sama , pake inner join kalau gak ada yg sama bakalan binung : Pakai inner join --> gak ada hasilnya pakai left,right,cross --> bakalan 9 Btw : kalau datanya cuma 3, coba tampilkan saja disini, kemudian hasil yg di inginkan apa? Salam Ronald Irawan Pt. Sanghiang Perkasa Gd. Graha Kirana Lt.5 Jl Yos Sudarso Kav.88 Jakarta "Eko" <[EMAIL PROTECTED]> Sent by: Programmer-VB@yahoogroups.com 31/05/2006 09:20 AM Please respond to Programmer-VB@yahoogroups.com To <Programmer-VB@yahoogroups.com> cc Subject Re: [Programmer-VB] join 2 table masing2 3 record saya sudah masuk SQL , wong saya testingnya di MySqL Front semua model join sudah saya pake, tapi hasilnya tetap 9 record   klo saya tambahin distinct cuma berkurang jadi 6 record padahal pinginnya Tabel A (3 record) join Tabel B (3 record) hasilnya tetap 3 record     ----- Original Message ----- From: dodik setiawan To: Programmer-VB@yahoogroups.com Sent: Tuesday, May 30, 2006 4:55 PM Subject: RE: [Programmer-VB] join 2 table masing2 3 record Sudah coba masuk SQL dan di DISTINCT   From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Eko Sent: Tuesday, May 30, 2006 16:13 To: Programmer-VB@yahoogroups.com Subject: [Programmer-VB] join 2 table masing2 3 record   Gimana ya caranya join 2 table yang masing2 terdiri dari 3 record tapi hasilnya tetap 3 record   saya coba pake inner/left/right join kok hasilnya selalu 9 record   Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:    http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:    [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:    Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to: [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Wahana Programmer Groups Links <*> Untuk mengunjungi sponsor milis ini, klik link berikut:     http://wahanaprogrammer.net <*> Untuk menghubungi owner milis ini, kirim email ke:     [EMAIL PROTECTED] <*> Konsultasi pemrogramman bisa chat disini:     Yahoo! Messenger: wahanaprogrammer SPONSORED LINKS Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language YAHOO! GROUPS LINKS  Visit your group "Programmer-VB" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.