Okay... Found something online that indicates that QoQ only supports inner joins (fine for me in this case) and only allows implicit, old school, joins ala:
SELECT * FROM table1, table2 It also does not allow aliases on said "tables" which sort of sucks, but whatevah... Just an update for those of you who care. -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 12:03 PM To: CF-Talk Subject: INNER/LEFT Joins in query of queries? I'm continuing work on my Basecamp API integration and have a question. Basecamp returns XML, which I am converting into a query object in certain cases. My goal is to convert the XML returned by several methods into a query, which I can then join using query of queries. So I have two queries, one named projects and the other named times. I read online that query of queries appears to allow joins, but in practice (CF7) it doesn't seem to be working. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
