Writting Select (SQL) for Salesforce Tasks (Open activities)

[#1]

Dears,

I am trying to retrieve information regarding the Salesforce Open Activities objects, but I am having problems making a load statement for that, in which only the data regarding the open activies for the object "Service Center Audit" can be retrieved.

The Salesforce admins have answered with this statement:

SELECT (SELECT SELECT AccountId, ActivityDate,   Description, Owner.Name, Status, Subject, What.Name, Who.Name  FROM OpenActivities Order By ActivityDate ASC, LastModifiedDate DESC LIMIT 500) FROM Service_Center_Audit__c

Does anyone know how to do that?

Thank you,

Julio César Lourenço

[#2]

Hello, you can not make a relationship table within salesforce from qlikview.

Sebas