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

vbPian Tue, 30 May 2006 21:20:49 -0700

SELECT JPPBD.*, JPOD.*
FROM JPOD RIGHT JOIN JPPBD ON (JPOD.Kd_BRG = JPPBD.Barang) AND (JPOD.No_PPB
= JPPBD.No_PPB)

udah saya coba di msaccess, hasilnya udah 3 row

-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of Eko
Sent: Wednesday, May 31, 2006 11:13 AM
To: [email protected]
Subject: Re: [Programmer-VB] join 2 table masing2 3 record

penambahan distinct sudah saya coba
cuma bisa mengurangi record jadi tinggal 6
ndak bisa jadi 3 record

----- Original Message -----
From: "Among Saliro" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, May 31, 2006 10:57 AM
Subject: Re: [Programmer-VB] join 2 table masing2 3 record

> tambah disctinct setelah select
>
>
> 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
>>
>>
>> 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
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

Wahana Programmer Groups Links

Yahoo! Groups Links

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.

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

Kirim email ke