select DISTINCT * from A,B
Where A.No_PPB = b.No_PPB
--- Eko <[EMAIL PROTECTED]> wrote:
> waduh...cara gini juga udah mas
> hasilnya juga 9 record
>
>
> ----- Original Message -----
> From: "Among Saliro" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Wednesday, May 31, 2006 10:42 AM
> Subject: Re: [Programmer-VB] join 2 table masing2 3
> record
>
>
> > coba, pasti hasilnya tiga baris saja
> >
> > 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
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Home is just a click away. Make Yahoo! your home
> page now.
>
http://us.click.yahoo.com/DHchtC/3FxNAA/yQLSAA/k7folB/TM
>
--------------------------------------------------------------------~->
>
>
> Wahana Programmer Groups Links
>
> http://wahanaprogrammer.net
>
> [EMAIL PROTECTED]
>
>
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
__________________________________________________
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.
