[pradeep]

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