Sorry? What do you mean by this?
It has been awhile, but I thought the syntax was tableA join tableB on ..... But I maybe wrong. 95% of the time I have been able to accomplish this type of requirement in the databases by linking one to another somehow. I have only a couple of times needed to do so in a QofQ manner. -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 20, 2007 10:14 AM To: CF-Talk Subject: RE: INNER/LEFT Joins in query of queries? > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:273161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
