Re: [SQL] Question about a select

2005-01-23 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Kretschmer Andreas <[EMAIL PROTECTED]> writes: > Hi, > I have a table with this columns: machine, date and area. > Now i need a view with machine an week, calculated from date, and > sum(area), where date between CURRENT_DATE and now+N days. > Okay, this is not the

[SQL] Question about a select

2005-01-22 Thread Kretschmer Andreas
Hi, I have a table with this columns: machine, date and area. Now i need a view with machine an week, calculated from date, and sum(area), where date between CURRENT_DATE and now+N days. Okay, this is not the problem, it works fine. (the original table and the view is more complex) The problem