--try
select b.FsoNo,x.FItemNo, w.FGrade, x.FSubitem
from t_sdorderqueue b, t_item w, t_bom x , t_item y
where
(b.FEntityNo *= w.FEntityNo and b.FItemNo = w.FItemNo) and
(w.FEntityNo *= x.FEntityNo and w.FItemNo = x.FItemNo) and
(x.FEntityNo *= y.FEntityNo and x.FSubItem = y.FItemNo) and
( b.FEntityNo = 'UU' )
select b.FsoNo,x.FItemNo, w.FGrade, x.FSubitem
from t_sdorderqueue b, t_item w, t_bom x , t_item y
where
(b.FEntityNo *= w.FEntityNo and b.FItemNo = w.FItemNo) and
(w.FEntityNo *= x.FEntityNo and w.FItemNo = x.FItemNo) and
(x.FEntityNo *= y.FEntityNo and x.FSubItem = y.FItemNo) and
( b.FEntityNo = 'UU' )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货