I'm not sure what the problem is. TQL isn't that different from SQL.
Create your joins manually and specify the properties you need from each of
Is there something unexpected happening?
On 11 October 2011 12:07, Robert Rawlins <rob...@supporttime.com> wrote:
> Hello Guys,--
> I have the following TQL query, which runs as expected:
> <cfsavecontent variable="LOCAL.TQL">
> Now, I want to create an additional join, this time from the Item object to
> I see details in the docs on how to do multiple joins from the Stock
> Stock -> Item -> Order
> So that I can collect a list of stock that is associated to a particular
> Can anyone offer any advice on this?
> Try out the new Transfer ORM Custom Google Search:
> You received this message because you are subscribed to the Google Groups
Blog : http://nil.checksite.co.uk/
Twitter : http://twitter.com/mr_nil
More Twitter : http://twitter.com/CFOverflow
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.