can anyone could have a look and let me know what is wrong with this query?
List projects = [SELECT id, Number_of_Assignments__c, Number_of_billable_assignments__c FROM Project__c WHERE id IN (SELECT Project__r.id, isActive__c FROM Assignment__c WHERE isActive__c = true)];
It throws this error
"unexpected token: ,"
Project__c Master, Assignment__c Child
I will be very grateful for your assistance