SELECT jppbd.*, jpod.* FROM jpod RIGHT JOIN jppbd ON ((jpod.Kd_BRG =
jppbd.Barang) AND (jpod.No_PPB = jppbd.No_PPB))
or ((jpod.Ket = jppbd.Ket) AND (jpod.No_PPB = jppbd.No_PPB)) where
jpod.No_PPB like '0004/PPB/032006'
makasih semua ya udah beri masukan, thanks
----- Original Message -----
From: "vbPian" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, May 31, 2006 11:24 AM
Subject: RE: [Programmer-VB] join 2 table masing2 3 record
> 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
>
>
>
>
> 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.
