strSQL = "SELECT A.店铺号,店名,B.地区,组,店类,店况,A.部门,Item,货品,"""",库存,在途,库存+在途,C.在途件数 FROM [" & ThisWorkbook.Path & "\报表信息.xlsx].[sheet1$]A left Join [" & ThisWorkbook.Path & "\日常转货.xlsm].[信息数据$]B on A.店铺号=B.店铺号 and left join [" & ThisWorkbook.Path & "\日常转货.xlsm].[在途件数$]C on A.店铺号=C.店铺 and A.Item=C.货号"
我想将三个表的数据合并起来,请问这句语句哪里出了问题?
strSQL = "SELECT A.店铺号,店名,B.地区,组,店类,店况,A.部门,Item,货品,"""",库存,在途,库存+在途,C.在途件数 FROM ([" & ThisWorkbook.Path & "\报表信息.xlsx].[sheet1$] A left Join [" & ThisWorkbook.Path & "\日常转货.xlsm].[信息数据$]B on A.店铺号=B.店铺号) left join [" & ThisWorkbook.Path & "\日常转货.xlsm].[在途件数$]C on A.店铺号=C.店铺 and A.Item=C.货号"
|