Trying to do a not in for a select statement but it returns all the rows in tblHomeOwnerJobHistory with the exception of plumber using the SQL below, I don't want anything being retrieved for that Home. Any ideas?
Code:
select *
from tblHome, tblHomeOwner, tblHomeOwnerJobHistory
where tblHome.id=1
and tblHomeOwner.homeid = tblHome.id
and tblHomeOwner.id = tblHomeOwnerJobHistory.homeownerid
and tblHomeOwnerJobHistory.retired = 'NO'
and tblHomeOwnerJobHistory.Job not in plumber