select * from A, B
where A.No_PPB = b.No_PPB
--- Eko <[EMAIL PROTECTED]> wrote:
> ndak ada primary key nya mas
> ----- Original Message -----
> From: Purwedi Kurniawan
> To: [email protected]
> 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: [email protected]
> 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
>
>
>
>
>
>
>
> SPONSORED LINKS Programmer Indonesia Basic
> programming language
> Computer programming languages Programming
> languages Java programming language
>
>
>
------------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "Programmer-VB" on the
> web.
>
> b.. To unsubscribe from this group, send an
> email to:
> [EMAIL PROTECTED]
>
> c.. Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service.
>
>
>
------------------------------------------------------------------------------
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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.
