How to get data from tow different object with same field if there is no relation between two objects using SOQL there is one common field between two objects.
I am trying the below query :
select Id,field1,field2,**commonfield** from **obj1** where Feature_ID__c in (select **commonfield** from **obj2** )
Getting error like semi join sub selects can only query id fields, cannot use.
How to write the SOQL for this?