jordon.shaw (3/30/2014)
SELECT IS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME
FROM INSPECTION IS
INNER JOIN INSPECTIONCONTACT CNT
ON IS.INSPNO = CNT.INSPNO
WHERE CNT.CAPACITY <> 'Contractor'
Quick note, be careful not to use reserved keywords in this manner, that is the alias for INSPECTION being IS.
SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME
FROM INSPECTION INS
INNER JOIN INSPECTIONCONTACT CNT
ON INS.INSPNO = CNT.INSPNO
WHERE CNT.CAPACITY <> 'Contractor'
😎