select tj02t.txt30, afvc.*
from afvc
inner join afko on
afko.aufpl = afvc.aufpl and afko.mandt = afvc.mandt
inner join jest
on jest.objnr = afvc.objnr and jest.mandt = afvc.mandt
inner join tj02t on
jest.stat = tj02t.istat and tj02t.spras = '1' and jest.inact <> 'X'
where afvc.mandt = '600' and afko.aufnr = '000210016599' -- 生产订单号
and afvc.vornr = '0010' -- 工序号