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 <*> 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/
