db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MassimoH <MassimoHei...@gmail.com>
Subject VALUES Query Question
Date Fri, 12 Dec 2008 06:18:37 GMT

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?

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.

View raw message