1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
| 2022/4/13 10:13:09 '1000630100090','1000630100091'
|
| 2022/4/13 10:13:09 select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
| from Sc_ICMOBillMain a
| left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
| left join Gy_Material m on a.HMaterID=m.HItemID
| left join Gy_Customer c on a.HCusID=c.HItemID
| left join Gy_Unit u on a.HUnitID=u.HItemID
| where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
| 2022/4/13 10:13:09 打印sql:select convert(varchar,a.HDate ,23)日期,a.HBillNo 单据编号,M.HName 销售物料名称,c.HName 收货方联系人,b.HQty 销售数量,u.HName 购货单位
| from Sc_ICMOBillMain a
| left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
| left join Gy_Material m on a.HMaterID=m.HItemID
| left join Gy_Customer c on a.HCusID=c.HItemID
| left join Gy_Unit u on a.HUnitID=u.HItemID
| where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
|
| 2022/4/13 10:13:10 ReportDataSet:2
|
|
