Select  Owner_Plasiyer__c from Account
where OWNER_ID__c in (Select ACCT_OWNER_ID__c from Contact)

semi join sub selects can only query id fields, cannot use: 'ACCT_OWNER_ID__c'