You don't have to do it that way. Try using sub-selects to get the
child data. I do this in DB2 all the time, here is an example.
SELECT
Col1,
Col2,
Col3,
(SELECT SUM(Revenue) FROM rev WHERE Order = A.Order) as
TotalRevenue
FROM
ORDER A
WHERE
Col1 = 'Whatever'
You can do as many of those sub-select as columns you need. Just ensure
that the data set is returning only a single record.
Also, you could do a nice Union All on your QoQ, if the fields are the
same.
If we still are not getting what your trying to do, maybe post some
code?
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274210
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
