[GENERAL] Tabulate data incrementally

[Omar Eljumaily]

I want to tabulate time data on a weekly basis, but my data is entered 
on a daily basis.

create table time_data
{
   employee varchar(10),
   _date date,
   job varchar(10),
   amount
}
So I want to tabulate with a single sql command.  Is that possible?

If I had a separate week end table
create table week_ends
{
   end_date date
}

I could do something like.

select *, (select sum(amount) from time_data where _date > end_date - 7 
and _data <= end_date) from week_ends;

But the week_end table would be a pain to manage for a number of 
reasons.  Is it possible to do this without the week_end table?

Thanks.


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster