Hi,

I want to create a very simple list of Opportunities with the last email date for each opportunity so that I can see who has not been followed up.

I can get this list outside Sugar with a simple three table MySQL join/group by query.

Is there a way of running this type of query within Sugar that does not involve installing complex and or expensive third party report packages or am I better off just setting up a set of quick PHP/MySQL reports outside Sugar?

Thanks

Emmett