select bd_bom.pk_corp, bd_bom.gcbm, bd_bom.pk_bomid, bd_bom.wlbmid, bd_bom.version, bd_bom.bblx, bd_bom.sl, bd_bom.sfmr, bd_bom.creat, bd_bom.jldwid as fjldwid, bd_bom.rgf, bd_bom.clf, bd_bom.zzf, bd_bom.zt, bd_bom.mver, bd_bom.bomlx, bd_bom.memo, bd_bom.zdy1, bd_bom.zdy2, bd_bom.zdy3, bd_bom.zdy4, bd_bom.zdy5, bd_bom.dr, bd_bom.ts, bd_invbasdoc.invcode, bd_invbasdoc.invname, bd_invbasdoc.invspec, bd_invbasdoc.invtype, fjl.measname as fjldwmc, bd_bom.pk_produce, bd_bom.sftpmr, bd_bom.gdsl, bd_bom.slsx, bd_b as om.slxx, bd_bom.fsl, bd_bom.fslsx, bd_bom.fslxx, bd_bom.gdfsl, bd_bom.hsl, zjl.measname as zjldwmc, zjl.pk_measdoc as zjldwid, bd_invbasdoc.graphid
from bd_bom
INNER JOIN
select bd_invbasdoc ON bd_bom.wlbmid = 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.jldwid = fjl.pk_measdoc