Could you please help me with the syntaxis of this SOQL Query? I would like to do an INNER JOIN between A and B on A.FamilyMember=B.ID
SELECT A.FamilyMember__c
FROM A
WHERE A.StartDate__c > TODAY AND A.EndDate__c < TODAY
AND (SELECT ID FROM B Where Membre__c = True)
AND
clause well enough to make a suggestion, though - can you add more description of your objective and your Salesforce data model?