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?
select *
from tblHome, tblHomeOwner, tblHomeOwnerJobHistory
and tblHomeOwner.homeid =
and = tblHomeOwnerJobHistory.homeownerid
and tblHomeOwnerJobHistory.retired = 'NO'
and tblHomeOwnerJobHistory.Job not in plumber