I appear to have solved this issue.
It looks to be something to do with me using type="numeric" in transfer,
but actually having the column datatype as varchar.
It appears that CF has some clever auto data-type recognition stuff going on
behind of QofQ's and this was confusing it.
Robert
--
Hello Guys,
I have the following TQL query, which runs as expected:
from inventory.Stock As Stock
join order.item As Item
where Stock.StockNumber = :StockNumber
Now, I want to create an additional join, this time from the Item object to
the 'Order' object.