Returning number of values from sub-query
From: <trpost_at_gmail.com>
Date: Mon, 21 Jan 2008 15:16:56 -0800 (PST)
Message-ID: <a2221205-9947-4a78-80fb-ffb8e34007ce@u10g2000prn.googlegroups.com>
Date: Mon, 21 Jan 2008 15:16:56 -0800 (PST)
Message-ID: <a2221205-9947-4a78-80fb-ffb8e34007ce@u10g2000prn.googlegroups.com>
I have the following query that returns 1 row:
SELECT REPORT_DATE, STARTS FROM SUBSCRIPTIONSUMMARYDATA WHERE
REPORT_DATE IN (TO_DATE('01/20/2008','MM/DD/YYYY'),
TO_DATE('01/21/2008','MM/DD/YYYY'))
REPORT_DATE STARTS
01/20/2008 100
What I am afer is to have 2 rows returned based on the values in the subquery, so I really want results like this:
REPORT_DATE STARTS
01/20/2008 100
01/21/2008
So I want 1 row returned for each row of the subquery. Any ideas, or how can I accomplish ths better. Received on Mon Jan 21 2008 - 17:16:56 CST