I have a module named "Online_Profiles", and another module named "Accounts". I am trying to make a COQL call to request data form various fields that are in the Accounts module based on a field that is in the Online_Profiles module.

Accounts has a "associated accounts" related list of Online_profiles. And Online_Profiles has a related list to show what accounts they are related to. I just cannot get the syntax correct. I have

select Phone from Accounts where Associated_Profiles.Name = 'Anthony'