query daily activityHistories

Hi guys,

We need to get daily activityhistories data for all the customers to integrate into a legacy system. I tried to query like this:

Select (Select b.Id, b.AccountId, b.ActivityDate From ActivityHistories b where b.ActivityDate=today) From Account a

Dose anybody know what's the problem in the query or it is another way that I should try? Thanks in advance.

Need an account? Sign Up

Have an account? Sign In