Hi All,
I have three SQL tables:
Orders - contains Date, OrderID,
ItemDescription - contains ItemID and ItemDesc,
Order_Items - a table that links the two on OrderID and ItemID (many-to-many).
I need to produce a report of how many items are in today's Orders, grouped by
ItemDesc (with a count), in ItemDesc Order.
Seems like a common-enough requirement, but I can't seem to find a result other
than doing one SELECT then looping thru the results with another select.
Is there a one-query solution please?
TIA
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
