You need to use table aliases
Code: SQL
SELECT j.SystemNumber, j.dwgnumber, j.quotenumber, j.ponumber, j.jobnumber, j.salesperson, j.draftsman, e1.empID, e1.empfirstname,
e1.emplastname, e2.empID, e2.empfirstname,
e2.emplastname, j.s, s.sID, s.scity, s.sstate, c.ID, c.firstname, c.lastname
FROM JobInfo j
INNER JOIN Employees e1 ON j.salesperson=e1.empID
INNER JOIN Employees e2 ON j.draftsman=e2.empID
INNER JOIN Store s ON j.s=s.sID
INNER JOIN customers c ON s.owner=c.ID
ORDER BY dwgnumber DESC LIMIT 10