Trying to do a not in a select statement
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?
from tblHome, tblHomeOwner, tblHomeOwnerJobHistory
and tblHomeOwner.homeid = tblHome.id
and tblHomeOwner.id = tblHomeOwnerJobHistory.homeownerid
and tblHomeOwnerJobHistory.retired = 'NO'
and tblHomeOwnerJobHistory.Job not in plumber