I'm having the hardest time trying to get what I believe should be an easy answer regarding a SOQL query that doesn't work in the Apex DataLoader (14.0)
A query created with Ajax Tools (2.0) returns expected results but when I run the query in the DataLoader I get a "Malformed Query" error. This is the case whether I run it with the DataLoader GUI or from the CLI.
SELECT Account.Name, Name, Amount, Probability, ExpectedRevenue, (SELECT Quantity, TotalPrice, UnitPrice, pricebookentry.productcode FROM OpportunityLineItems) FROM Opportunity Where amount > 4000000
Any help is greatly appreciated