I want to do a query like this: SELECT Months.????, (SELECT SUM(Amount) FROM Sales WHERE SaleMonth = Months.????) AS Sales FROM (VALUES '2008-01-01', '2008-02-01', '2008-03-01', '2008-04-01', '2008-05-01', '2008-06-01', '2008-07-01') AS Months;
However, when I use VALUES in a sub-query, I don't see how to reference the column. Basically, how can I get the above query to work? Thanks! -- View this message in context: http://www.nabble.com/VALUES-Query-Question-tp20970481p20970481.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
