SQL加上order by 后报错 Post By:2012/11/17 10:47:00 [只看该作者]
求解:
Tables(e.Form.Name &"_Table1").Fill("select b.销售订单id, b.销售单号 ,b.订单日期 ,b.客户id,a.订单明细id from {销售明细} a left join {销售订单} b on a.销售订单id = b.销售订单id where b.订单日期 = '" & d1 & "' order by b.销售订单id,a.销售明细id ","JRRJ",True)