Re: SQL

Hi!

For example:

Create a table month with column month# Number(2) and populate it with all

the months 1 .. 12

Select '2000' || m.month# "Period", p.customer_budget/12 "Budget" From Project p, Month m
Where m.month# between 3 and 8;

This will list the result of customer_budget/12 six times, one for each m onth march .. august.

Nj l Received on Fri Jun 16 2000 - 00:00:00 CDT