Sorry, after thinking about it I can now answer my own question: you can't combine QoQ with any kind of join because a join requires at least 2 tables. In a QoQ situation, the <CFQUERY> statement can only refer to an earlier query, so the query can't possibly access another (real) table. I would be happy to be proven wrong though...
Regards: Ayudh +----------------------------------------------------------------+ | SOAP is the glue! Hook up your server directly to your bank. | | Connect to VeriPay xServ, the Australian Payments Web Service. | | Reliable, Secure, FAST: http://www.xilo.com/xserv | +----------------------------------------------------------------+ ----- Original Message ----- From: "Ayudh Nagara" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Monday, July 05, 2004 6:31 PM Subject: [cfaussie] QoQ & joins > Hi, > Does anyone know if there is a restriction in using Query of Queries results > in a join? In particular, I am trying to do a LEFT OUTER JOIN where the > right "table" is the result of an earlier query and I'm getting all kinds of > SQL syntax errors (using MS SQL). No problem running the same query against > real tables. > > Regards: Ayudh > > +----------------------------------------------------------------+ > | SOAP is the glue! Hook up your server directly to your bank. | > | Connect to VeriPay xServ, the Australian Payments Web Service. | > | Reliable, Secure, FAST: http://www.xilo.com/xserv | > +----------------------------------------------------------------+ > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
