> And one just uses the JOIN keyword, don't use 'INNER' Sorry? What do you mean by this?
-----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 12:11 PM To: CF-Talk Subject: RE: INNER/LEFT Joins in query of queries? My first question is can anyone confirm if QoQ allows joining? My second question is what's the syntax? Here's my SQL (pretty vanilla): Yes, but IIRC only inner joins, no left or right joins. And one just uses the JOIN keyword, don't use 'INNER' Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
