SELECT dbo_View_JobProd.jpJobNum, 
dbo_View_JobProd.jpTargetJobNum, 
dbo_View_JobAsmbl.jaAssemblySeq, 
dbo_View_JobAsmbl.jaPartNum, 
dbo_View_JobAsmbl.jaDescription, 
dbo_View_JobOper.joOprSeq, 
9999 AS jmMtlSeq,
dbo_View_JobOper.joOpDesc, 
dbo_View_JobOper.joCommentText
FROM (dbo_View_JobProd LEFT JOIN dbo_View_JobAsmbl ON dbo_View_JobProd.jpJobNum = dbo_View_JobAsmbl.jaJobNum) LEFT JOIN dbo_View_JobOper ON (dbo_View_JobAsmbl.jaAssemblySeq = dbo_View_JobOper.joAssemblySeq) AND (dbo_View_JobAsmbl.jaJobNum = dbo_View_JobOper.joJobNum)
WHERE (((dbo_View_JobProd.jpJobNum)=[Forms]![frmFAI]![cboJobNum])) OR (((dbo_View_JobProd.jpTargetJobNum)=[Forms]![frmFAI]![cboJobNum]))

UNION SELECT dbo_View_JobProd.jpJobNum, 
dbo_View_JobProd.jpTargetJobNum, 
dbo_View_JobAsmbl.jaAssemblySeq, 
dbo_View_JobAsmbl.jaPartNum, 
dbo_View_JobAsmbl.jaDescription,
9999, 
dbo_View_JobMtl.jmMtlSeq, 
dbo_View_JobMtl.jmPartNum, 
dbo_View_JobMtl.jmDescription
FROM (dbo_View_JobProd LEFT JOIN dbo_View_JobAsmbl ON dbo_View_JobProd.jpJobNum = dbo_View_JobAsmbl.jaJobNum) LEFT JOIN dbo_View_JobMtl ON (dbo_View_JobAsmbl.jaAssemblySeq = dbo_View_JobMtl.jmAssemblySeq) AND (dbo_View_JobAsmbl.jaJobNum = dbo_View_JobMtl.jmJobNum)
WHERE (((dbo_View_JobProd.jpJobNum)=[Forms]![frmFAI]![cboJobNum])) OR (((dbo_View_JobProd.jpTargetJobNum)=[Forms]![frmFAI]![cboJobNum]));

Select all