Kemudian bentuk kelaur datanya seperti apa yah ?apakah seperti ini
select a.* from lotxlocxid A where a.lot in ( select lot from lotatribute where storer='" & txtstorer.text & "')"
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "hasan" <[EMAIL PROTECTED]>
Sent by: [email protected] 25/11/2005 10:52 AM
|
|
Maaf...
Yg jd primary key di lotxlocxid itu lot dan loc,selain itu ada jg
field qty,sku dan qtyallocated
Thanx....
Hasan
MM2100 Industrial Park
--- In [email protected], Ronald Irawan <[EMAIL PROTECTED]>
wrote:
>
> LOoooH *gaya extravaganza...
> key di table lotxlocxid apa yah ?
>
> Salam
> Ronald Irawan
> Pt. Sanghiang Perkasa
> Gd. Graha Kirana Lt.5
> Jl Yos Sudarso Kav.88
> Jakarta
>
>
>
> Hasan <[EMAIL PROTECTED]>
> Sent by: [email protected]
> 24/11/2005 02:40 PM
> Please respond to
> [email protected]
>
>
> To
> [email protected]
> cc
>
> Subject
> [Programmer-VB] Bisa Bantu Ga
>
>
>
>
>
>
>
> Rekans,saya mo tanya neh...
> Gimana seh coding di VB kl kt mo cari data yg
> sama,jd
> gini,2 tabel,saya dah buat coding untuk mencari data
> lot,gini :
> lotatrribute fieldnya ada lot,storer n dll...
> strsql=select lot from lotattribute where
> storer=txtstorer.text
>
> Kl kita cari di query analyzer,akan klr data lot ga
> hanya satu record,tp bbrp skaligus,y minimal 2
> record....
> kemudian saya mo cari ditabel lotxlocxid yg isi data
> lot nya sama dengan data yg sudah didapat diatas,tp
> tdk ada field storer ditabel ini,gimana y
> codingnya????
> Tlg bantuannya y...
> Thanx b4....
>
>
>
>
> __________________________________
> Yahoo! Music Unlimited
> Access over 1 million songs. Try it free.
> http://music.yahoo.com/unlimited/
>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
> Yahoo! Groups Links
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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.
