Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
469 B
2
Indexable
Never
"select distinct BMG15D.[BMG15D_Branch_Code], Branches.[Branch name], Branches.[Branch Number], Branches.[Branch old code]  from BMG15D " & _
                             "LEFT OUTER JOIN [Branches] ON BMG15D.BMG15D_Branch_Code = Branches.[Branch old code] " & _
                             "where BMG15D_batchdate  = '" & Format(CType(cmbdate.SelectedValue.ToString, Date), "MM/dd/yyyy") & "' " & _
                             "order by Branches.[Branch name] asc
Leave a Comment