select bd_bom_b.pk_corp, bd_bom_b.gcbm, bd_bom_b.pk_bom_bid, bd_bom_b.sdate, bd_bom_b.edate, bd_bom_b.pk_bomid, bd_bom_b.hh, bd_bom_b.zxbmid, bd_bom_b.sl, bd_bom_b.xelwfw, bd_bom_b.jldwid as fjldwid, bd_bom_b.shxs, bd_bom_b.zzgx, bd_bom_b.zzwz, bd_bom_b.tlwz, bd_bom_b.sftdl, bd_bom_b.zxlx, bd_bom_b.sfkxj, bd_bom_b.gylx, bd_bom_b.flckid, bd_bom_b.pzbl, bd_bom_b.pztqq, bd_bom_b.sfwwfl, bd_bom_b.kzbz, bd_bom_b.memo, bd_bom_b.zdy1, bd_bom_b.zdy2, bd_bom_b.zdy3, bd_bom_b.zdy4, bd_bom_b.zdy5, bd_invbasdoc.invcode, bd_invbasdoc.invname, bd_bom_b.dr, bd_bom_b.ts, bd_invbasdoc.invspec, bd_invbasdoc.invtype, fjl.measname as fjldwmc, bd_bom_b.pk_produce, bd_bom_b.blfs, bd_bom_b.gyfs, bd_bom_b.sfdc, bd_bom_b.sfjc, bd_bom_b.sfzl, bd_bom_b.xsckid, bd_bom_b.zpzh, bd_invbasdoc.graphid, zjl.measname as zjldwmc, bd_bom_b.fsl, bd_bom_b.hsl, bd_bom_b.sffl, zjl.pk_measdoc as zjldwid
from bd_bom_b
INNER JOIN
select bd_invbasdoc ON bd_bom_b.zxbmid = bd_invbasdoc.pk_invbasdoc
INNER JOIN
select bd_measdoc zjl ON bd_invbasdoc.pk_measdoc = zjl.pk_measdoc
LEFT OUTER JOIN
select bd_measdoc fjl ON bd_bom_b.jldwid = fjl.pk_measdoc