I need help with this SOQL statement. I need it to return results from Account object based on a subquery. What I have below doesn't work. The objects are 1:1 relationship. There is an External ID on Business__c and Account object.
SELECT ID, Combine__c FROM Account WHERE Combine__c IN ( SELECT ID, Combine__c FROM Business__c )