I am trying to identify any CASE records that have a email in custom field that matches personemail in account object. in sql I would write this something like this.. what is the corresponding soql query?
select id from case c
(select 1 from account a
where a.personemail = c.contact_email__c )