Kalau boleh tahu hubungan antara table 1 dan 2 itu apa? apakah 1 to many, terus hub table 1 dan 3 itu apa juga? apakah 1 to many juga.
Kalau memang 1 to many mungkin reportnya lebih bagus ada level breaknya di Anggota jadi kurang lebih di qreport kamu ada 1 detail dan 1 subdetail dimana detail berisi anggota sedangkan subdetailnya berisi pinjaman mungkin ya kurang lebih querynya SELECT A.no_ang, A.nama, A.divisi + '/' + A.bagian, B.nilai, C.angsurang + B.nilai + C.angsuran FROM table1 as A, table2 as B, table3 as C WHERE A.no_ang=B.no_ang and A.no_ang=C.no_ang and B.no_ang=C.no_ang CMIIW Smoga membantu :) --- changan chai <[EMAIL PROTECTED]> wrote: > > Halo teman-teman delphindo > > Mau nanya lagi kalau saya punya 3 table sbb : > > 1. Anggota (no_ang, nama, divisi, bagian) > > 2. OPR (no_ang, nilai) > > 3. Khusus (no_ang, pinjaman, angsuran) > > kalau print pakai qreport dan writeln harus gimana > ya supaya bisa hasil sbb : > > no_ang nama divisi/bagian nilai angsuran > nilai+angsuran > > > > Terima kasih > > salam > > changan > > > > --------------------------------- > Do you Yahoo!? > Yahoo! Platinum - Watch CBS' NCAA March Madness, > live on your desktop! > > [Non-text portions of this message have been > removed] > > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com ------------------------ Yahoo! Groups Sponsor ---------------------~--> Get 128 Bit SSL Encryption! http://us.click.yahoo.com/xaxhjB/hdqFAA/xGHJAA/i7folB/TM ---------------------------------------------------------------------~-> Berlangganan: [EMAIL PROTECTED] Stop Berlangganan: [EMAIL PROTECTED] Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
