誰能幫我簡化這條sql語句啊
select * from
(select
id_on1 = finished_product_bom.id_on,
finished_product_bom.CreateDate,
finished_product_bom.Fcode,
finished_product_bom.Material,
finished_product_bom.Model,
finished_product_bom.Cname,
finished_product_bom.Provider,
finished_product_bom.Saleman,
finished_product_bom.Customer,
finished_product_bom.Bwidth,
finished_product_bom.Highten,
finished_product_bom.Color,
finished_product_bom.Tunit,
finished_product_bom.Unit,
finished_product_bom.Lwidth,
finished_product_bom.Price,
finished_product_bom.UseSize,
finished_product_bom.Loss,
finished_product_bom.Qty,
finished_product_bom.Amount,
finished_product_bom.Weight,
finished_product_bom.Memo,
finished_product_bom.Totalweight,
finished_product_bom.Approve,
finished_product_bom.Operater,
finished_product_bom.Flag,
finished_product_bom.Pitem,
finished_product_bom.Note,
finished_product_bom.KnifeNum,
finished_product_bom.picturparn,
finished_product_bom.picturpath,
finished_product_bom.bomn001,
finished_product_bom.bomn002,
finished_product_bom.bomn003,
finished_product_bom.bomn004,
finished_product_bom.bomn005,
finished_product_bom.bomn006,
finished_product_bom.bomn007,
finished_product_bom.bomn008,
finished_product_bom.bomn009,
finished_product_bom.bomn010,
finished_product_bom.bomn011,
id_on2 = null,
Preface =null,
Style_number = null,
Wpreface =null,
sstime =null,
Yield =null,
Uprice =null
from finished_product_bom
where bomn002 <> all(select distinct Style_number from Engineering)
這是一半，下面接
[解决办法]
后面两个UNION语句的COUNT改成NULLIF(COUNT(*),0)估计应该和你的逻辑一致.当然我没有你的数据结构和约束,只能凭对SQL语法的理解尽量的接尽你的结果.如果你能给出相关的约束和适当的验证数据,我相信你的语句是肯定能化简的
