+ Start a Discussion

Need query tool to do simple inner join of three objects and extract 250K rows to flat file

I need to run a query selecting some fields from OpportunityLineItem, PricebookEntry, and Product2.  That's a simple inner join.  I can do the query in Apex Explorer but it's impractical to get 250K rows out.


Anyone know a better query tool for doing larger queries to flat files?



Santhosh KumarSanthosh Kumar

Have you tried Apex Data Loader?