---------- Original Message ---------------------------------- From: "Robertson-Ravo, Neil (RX)" <Neil.Robertson-
>ColdFusion does not support OUTER JOIN or INNER JOIN syntax, as the >following example shows it does however support INNER JOINs between two >tables : > >SELECT product_ID, shipping_ID >FROM product, shipping >WHERE product.product_ID = shipping.shipping_ID Are you talking about only within Query of Queries (as Sean asked) or in general. Your example looks like a regular (non-QofQ) query, and I can tell you that ColdFusion DOES support Outer Join and Inner Join syntax (for at least SQL Server and Oracle, if nothing else), because I use it all the time (particularly in Oracle). I don't think you can use any joins within a QofQ, because I don't think you can query 2 separate queries. (However, I'm not certain of that, having never tried it.) -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
