...follows (no laughing I'm self taught!) : -
SELECT JOBOPER.JOBNUM, JOBOPER.OPCODE, JOBOPER.ESTPRODHOURS, JOBOPER.PRODLABRATE, (JOBOPER.ESTPRODHOURS*JOBOPER.PRODLABRATE)+JOBOPER.ESTUNITCOST, JOBOPER.ACTLABCOST, JOBOPER.OPCOMPLETE, JOBHEAD.PRODCODE,(SELECT TOP(1) EMPLOYEENUM FROM LABORDTL WHERE...