Untitled

"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