I am having a hard time with a SOQL query. I want some data from a table using two like conditions on
Name. How can I correct my query so that it is a single query rather than two separate queries?
Select Id, Name , Isactive, sobjecttype from recordtype where (select Name from recordtype where sobjecttype = 'Insurance_Product__c' and isactive = true ) = (select Name from recordtype where sobjecttype = 'Policy__c' and isactive = false))