Re: QofQ Joins

2003-01-21 Thread Dave Carabetta
>Is it possible to do an outer join in a query of queries? I can't find >any good documentation that explains QofQ's capabilities/limitations. > >It seems to support inner joins, but I haven't come up with an outer >join syntax that doesn't throw an error. > I found this article to be extremely he

RE: QofQ Joins

2003-01-21 Thread Robertson-Ravo, Neil (RX)
:-) it does work in QoQ -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:22 To: CF-Talk Subject: RE: QofQ Joins -- Original Message -- From: "Robertson-Ravo, Neil (RX)" >This is a commonly r

RE: QofQ Joins

2003-01-21 Thread Scott Brady
-- Original Message -- From: "Robertson-Ravo, Neil (RX)" >This is a commonly referred to as JOIN between tables > Yeah, but I've never seen it in action with QoQ, so I wasn't sure if that's what you were demonstrating. Thanks for clarifying.

RE: QofQ Joins

2003-01-21 Thread Robertson-Ravo, Neil (RX)
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

RE: QofQ Joins

2003-01-21 Thread Robertson-Ravo, Neil (RX)
only with Query of Queries.ColdFusion doesn't give a stuff what SQL you use as long as its valid for the DB or ODBC (etc) driver. -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 16:08 To: CF-Talk Subject: RE: QofQ Joins -- Ori

RE: QofQ Joins

2003-01-21 Thread Scott Brady
-- Original Message -- From: "Robertson-Ravo, Neil (RX)" 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,

RE: QofQ Joins

2003-01-21 Thread Denny Sheridan
niels [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:52 AM To: CF-Talk Subject: QofQ Joins Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven'

RE: QofQ Joins

2003-01-21 Thread Robertson-Ravo, Neil (RX)
Daniels [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 15:52 To: CF-Talk Subject: QofQ Joins Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven'

QofQ Joins

2003-01-21 Thread Sean Daniels
Is it possible to do an outer join in a query of queries? I can't find any good documentation that explains QofQ's capabilities/limitations. It seems to support inner joins, but I haven't come up with an outer join syntax that doesn't throw an error. Thanks, - Sean ~~