strSql = "select T.no_Transkasi,P.no_peminjaman, P.Kd_nasabah, N.Nm_Nasabah, P.Jml_Angsuran, T.Angsuran_Ke, T.Denda, T.Jml_Pembayaran, A.User_Name" & _
                    " FROM ((tb_transaksi T left JOIN tb_Peminjaman P ON T.No_peminjaman = P.no_peminjaman)" & _
                    " left JOIN Tb_Nasabah N ON P.Kd_nasabah = N.Kd_nasabah)" & _
                    " left JOIN Tb_admin A On T.Id_admin = A.Id_Admin " & _
                    " Where T.No_transkasi = '" & TextBox1.Text & "'"
       

Comments

Popular Posts