SELECT product_ID, shipping_ID >FROM product, shipping >WHERE product.product_ID = shipping.shipping_ID
This is a commonly referred to as JOIN between tables.... -----Original Message----- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:08 To: CF-Talk Subject: RE: QofQ Joins ---------- 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
