Code: SQL
SELECT JobInfo.SystemNumber,
        JobInfo.dwgnumber,
        JobInfo.quotenumber,
        JobInfo.ponumber,
        JobInfo.jobnumber,
        JobInfo.salesperson,
        JobInfo.draftsman,
        sp.empID AS salesId,
        sp.empfirstname AS salesfirstname,
        sp.emplastname AS saleslastname,
        dm.empID AS draftId,
        dm.empfirstname AS draftfirstname,
        dm.emplastname AS draftlastname,
 FROM JobInfo
 INNER JOIN Employees AS sp ON JobInfo.salesperson = sp.empID
 LEFT JOIN Employees AS dm ON JobInfo.draftsman = dm.empID