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

[Eko]

 ndak ada primary key nya mas ----- Original Message ----- From: Purwedi Kurniawan To: Programmer-VB@yahoogroups.com Sent: Wednesday, May 31, 2006 10:29 AM Subject: Re: [Programmer-VB] join 2 table masing2 3 record ada yg table yg primary keynya 2 ga?   On 5/31/06, Eko <[EMAIL PROTECTED]> wrote:  sama aja mas pur...cara itu sdh saya coba, hslnya 9 record ----- Original Message ----- From: Purwedi Kurniawan To: Programmer-VB@yahoogroups.com Sent: Wednesday, May 31, 2006 10:01 AM Subject: Re: [Programmer-VB] join 2 table masing2 3 record   kalau gini gimana:   select b.No_PO,b.No_PPB,b.KD_BRG,b.QTY,b.QTYT,b.Ket, a.qty as pbd_qty, a.qty_order from jpod b left join jppbd a on b.no_ppb = a.no_ppb where b.No_PPB like '0004/PPB/032006' sincera [wwn]   On 5/31/06, Eko <[EMAIL PROTECTED] > wrote: 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 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.