0 Replies Latest reply: Mar 19, 2013 2:01 PM by sohrmann RSS

    Salesforce SOQL/SQL Syntax (Join)

      Hey there,

       

      I am trying to join Salesforce tables using the Qlikview connector, however none of the options I tried work. Can anyone advice on the syntax needed to join tables (on a key). Both SQL and SOQL failed me.

       

      For example, I would like to know the actual username of a case owner. So in SQL, this would kinda look like:

       

      SELECT c.id, c.subject, u.name
      FROM case c
      JOIN user u on u.id = c.ownerId
      

       

      SOQL:

      SELECT id, subject, owner.name
      FROM case
      

       

      Also, I am unsure what functions I can use - according to the user guide, both SQL and SOQL are valid and were 'combined', however I was unable to format my createdDate using DATE_FORMAT(). Is there a definite list or should I mostly rely on SOQL functions?