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'
😎
Thanks for the tip; however, I'm actually using completely different alias all together. I just tried to simplify this to make it easy for y'all to help. With that being said, any suggestions on how to accomplish what I'm trying to accomplish?
Thanks,
Jordon