8 Replies Latest reply on Sep 17, 2014 2:45 AM by Pranav K

    Weird issue while querying Salesforce through Teiid embedded

    Pranav K Novice

      Hi,

       

      I was using the Teiid sample code to test out certain queries through Teiid embedded when I noticed that changing the order of FROM part of a working query gave me an error.

       

      This gave me an error:

      SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Account, Contact WHERE Account.Id = Contact.AccountId

       

      Whereas the following ran fine:

      SELECT Account.Phone, Account.Name, Account.Type, Contact.LastName FROM Contact, Account WHERE Contact.AccountId = Account.Id

       

      I am looking into what could be the issue. Meanwhile does anybody have any pointer to what could be the issue?

       

      Thanks,

       

      Pranav