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
>
>
>
>
>
>
>
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.
