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 & "'"
" 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
Post a Comment