trus, bagaimana menampilkan hasilnya melalui vb? ----- Original Message ----- From: "budiman Lai" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, February 02, 2006 12:42 AM Subject: Re: [Programmer-VB] Relational Database
> sSQL = "SELECT b.KDBRG as KDBRG, b.NMBRG as NMBRG, > t.JLH_TRN as JLH_TRN " > sSQL = sSQL & "FROM barang b " > sSQL = sSQL & "LEFT JOIN transaksi t ON t.KD_BRG = > b.KDBRG" > > Database.Query(sSQL) > > --- skdmdn <[EMAIL PROTECTED]> wrote: > > > Teman, > > > > Saya mempunyai tabel sbb: > > > > Tabel Barang: > > > > KDBRG NMBRG > > 01 B > > 02 C > > > > Tabel Transaksi > > > > KD BRG JLH_TRAN > > 01 12 > > 02 10 > > > > Bagaimana syntaxnya di vb untuk menampilkan report > > seperti ini: > > > > KDBRG NMBRG JLH_TRAN > > 01 B 12 > > 02 C 10 > > > > Thank's.Maap pertanyaanya mendasar sekali. > > > > > > > > > > > > > __________________________________________________ > 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 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/
