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

Tue, 30 May 2006 20:01:26 -0700

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



Kirim email ke