You can actually use the old SQL syntax to do inner joins in a qoq,
haven't gotten a left join to work though.
this fails:
<cfquery dbtype="query" name="tmp">
SELECT *
FROM t1 inner join t2
ON t1.id = t2.id
</cfquery>
this works though:
<cfquery dbtype="query" name="tmp">
SELECT *
FROM t1, t2
WHERE t1.id = t2.id
</cfquery>
~Mahcsig
On Mon, Oct 25, 2010 at 1:35 PM, Paul Alkema
<[email protected]> wrote:
>
> Hi Nathan,
> Both cf8 and cf9 allow for left outer joins when doing normal queries
> however as far as I know query of query's does not support joins.
>
> On a side note though, my general rule of thumb is if I need to use a query
> of queries for anything other than changing the order of my structure, than
> I really need to evaluate my original SQL query and looped query of queries
> are big programming no no.
>
> Just my 2 cents.. : )
>
> Paul Alkema
> http://paulalkema.com/
>
>
> -----Original Message-----
> From: Nathan Chen [mailto:[email protected]]
> Sent: Monday, October 25, 2010 1:53 PM
> To: cf-talk
> Subject: left outer join in query of query
>
>
> All:
>
>
>
> I am on CF 8 now. Does anyone know if CF 9 supports left outer join in
> query of query? CF 8 doesn't allow left outer join.
>
>
>
> Nathan Chen
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338527
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
