表A的查询语句:
SELECT e.empName,b.OrderNum,c.CustName,b.OrderMoney from SaleOrderHedTB a
left join SaleOrderDetTB b on a.SaleOrderNo=b.SaleOrderNo
left join EmployeeTB e on a.Seller=e.EmpID
left join CustomerMasterTB c on a.CustId=c.CustId
where 1=1
and a.OrderDate BETWEEN '2018-09-01' and '2018-09-04'
and a.AuditFlag=1