What is the proper way nest my Left Outer Joins. In another ODBC driver I can use:
SELECT count(TimeTracking.ROWID) FROM ((TimeTracking LEFT OUTER JOIN Customer ON Customer.ListID = TimeTracking.CustomerRefListID) LEFT OUTER JOIN Entity ON Entity.ListID = TimeTracking.EntityRefListID) LEFT OUTER JOIN PriceLevelPerItem ON PriceLevelPerItem.ListID = Customer.PriceLevelRefListID SQLite does not seem to like the Parens and leaving them off causes it to give me a PriceLevelPerItem record for every TimeTracking Record which does not seem right. (Basically like a where condition not a left outer join) SELECT count(TimeTracking.ROWID) FROM TimeTracking LEFT OUTER JOIN Customer ON Customer.ListID = TimeTracking.CustomerRefListID LEFT OUTER JOIN Entity ON Entity.ListID = TimeTracking.EntityRefListID LEFT OUTER JOIN PriceLevelPerItem ON PriceLevelPerItem.ListID = Customer.PriceLevelRefListID Currently using 3.2.2 (Built by SQLCrypt) Thanks, Matt Froncek QODBC Development Support / FLEXquarters Solutions Consultant QODBC Driver for QuickBooks - Unleash your data at <http://www.qodbc.com/> www.qodbc.com
