Using Subquery in FROM clause

[ABC123]

Hi. Can someone help me out and tell me why this subquery will not work?? I know its a long query but thats what i need....

SELECT Date_Ordered, SUM(sum1) FROM (SELECT Date_Ordered, Item_Code, sum(IF(Order_Qty < Received_Qty, Order_Qty, Received_Qty)) as sum1 FROM Bakery_Inventory
WHERE ((Store='123456') AND (Date_Ordered BETWEEN '2005-04-01' AND '2005-04-02') AND ((Item_Code LIKE 'YTR%') OR (Item_Code LIKE 'YTL%')))
GROUP BY Date_Ordered, Item_Code) AS sum GROUP BY Date_Ordered

[raf]

It doesn't work because the FROM needs to be a tablename and not a recordset

A select-subquery would be
select var from table where varID IN (select var2 from table2)

but i'm quite certain there should be an easier way to achieve what you want (whatever it is)