Create a view to return multiple rows based on the column values of a single row, How?

[Quoted] OK! SQL Gurus, here is what I have:

[Quoted]
• Say I have a table, eg Period, whith two columns, eg First_Date_Of_Month (date) and Number_Of_Days (integer). For every month there is only on entry in it which are the date of the 1st day of [Quoted] the month and the number of days in that month. eg:

First_Date_Of_Month Number_Of_Days

01-jan-2000         31
01-feb-2000         29
01-mar-2000         31

And here is what I would like to get:

• A view, eg Period_View, which will produce me the follwing result based on the row in the above table:

SELECT day_of_the_month, date_of_the_day FROM Period_View WHERE   First_Date_Of_Month = '01-feb-2000';

day_of_the_month date_of_the_day

01               01-feb-2000
02               02-feb-2000

Is this possible? If so how?
Thanks for any help!
Adam.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 30 2000 - 00:00:00 CEST