Hi,
I would like to perform the following results from a query either in CRM or SQL directly
Select all the Active Contacts (Contact ENTITY) email addresses from active Accounts (Account ENTITY) excluding a country that do not have a contract (Contract ENTITY)
so results should be similar to
Company 1 Contact 1 email address
Contact 2 email address
Company 2 Contact 3 email address
Company 3 Contact 4 email address
Contact 5 email address
How can this easily be achieved.
Any help is greatly appreciated.
