select e.CFPRICE CFTonfreight from CT_DUC_FreightUnit a left join CT_DUC_FreightUnitE1 e on e.FParentID=a.fid and e.CFCUSTOMERID='10YAAAADA7y/DAQO' and e.CFSUPPLYNUMBERID='10YAAAACFbY3xn38' and a.CFAPPCOMPANYID='10YAAAAAGSPM567U'
select e.CFPRICE CFTonfreight from CT_DUC_FreightUnit a left join CT_DUC_FreightUnitE1 e on e.FParentID=a.fid WHERE e.CFCUSTOMERID='10YAAAADA7y/DAQO' and e.CFSUPPLYNUMBERID='10YAAAACFbY3xn38' and a.CFAPPCOMPANYID='10YAAAAAGSPM567U'
别人的详细分析链接:https://blog.csdn.net/minixuezhen/article/details/79763263
金蝶的dep中 貌似 后面只能用and, 其他的语法保存的时候报错