老师，表我是通过SQL语句生产的，请问该怎么写
Dim cmd As New SQLCommand
Dim dt As DataTable
Dim cmb As WinForm.ComboBox
cmd.ConnectionNa me = "ce s hi"
cmd.CommandText = "SE LE CT DISTINCT top 2000 a.FDate as 日期,c.FName as 领料部门,a.FBillNo as 单据编号,e.fname as 发料仓库,a.FCheckDate as 审核日期 From " & _
" ICStockBill a left join ICStockBillEntry b on a.FInterID = b.FInterID left join t_Department c on a.FDeptID = c.FItemID " & _
" left join t_Stock e on b.FSCStockID = e.FItemID left join t_ICItem d on b.FItemID = d.FItemID left join t_MeasureUnit f on b.FUnitID = f.FMeasureUnitID left join t_Emp g on a.FSManagerID = g.FItemID " & _
" left join t_User h on a.FBillerID = h.FUserID left join t_User i on a.FCheckerID = i.FUserID " & Filter
dt = cmd.ExecuteReader()
Tables("生产领料单查询_Table1").DataSource = dt
加好友 
发短信
Post By：2019/11/23 8:54:00 [只看该作者]
此主题相关图片如下：企业微信截图_20191123084940.png