Sql脚本参考：

select t1.FBILLNO as 单据编码,t4.FNAME as 销售部门, t1.FDATE as 销售日期,t5.FNAME as 客户,t3l.FNAME as 销售员

,t6.fnumber as 物料编码,t6l.fname as 物料名称,t6l.FSPECIFICATION as 规格型号,t7.FNAME as 销售单位,t2.FQTY as 销售数量

,t2R.FSTOCKOUTQTY as 累计出库数量,t2D.FDELIVERYDATE as 要货日期,t8.FNUMBER as BOM版本

from T_SAL_ORDER t1 --销售订单

inner join T_SAL_ORDERENTRY t2 on t1.FID=t2.FID --销售订单.明细

left join T_SAL_ORDERENTRY_R t2R on t2.FENTRYID=t2R.FENTRYID --销售订单.明细.拆分表(关联关系)

left join T_SAL_ORDERENTRY_D t2D on t2.FENTRYID=t2D.FENTRYID --销售订单.明细.拆分表(交货安排)

left join V_BD_SALESMAN_L t3l on t1.FSALERID=t3l.fid and t3l.FLOCALEID=2052 --销售员

left join T_BD_DEPARTMENT_L t4 on t1.FSALEDEPTID=t4.FDEPTID and t4.FLOCALEID=2052 --部门

left join T_BD_CUSTOMER_L t5 on t1.FCUSTID=t5.FCUSTID and t5.FLOCALEID=2052 --客户

left join T_BD_MATERIAL t6 on t2.FMATERIALID=t6.FMATERIALID --物料

left join T_BD_MATERIAL_L t6l on t6.FMATERIALID=t6l.FMATERIALID and t6l.FLOCALEID=2052 --物料多语言

left join T_BD_UNIT_L t7 on t2.FUNITID = t7.FUNITID and t7.FLOCALEID=2052 --计量单位

left join T_ENG_BOM t8 on t2.FBOMID = t8.FID --物料清单(bom)

产品问题求一条SQL语句，显示销售订单列表中，未出完货的订单明细

20 产品问题 求一条SQL语句，显示销售订单列表中，未出完货的订单明细