> View definition: SELECT mileage.miles, mileage.date FROM mileage;
> detail=# select mileage.miles, mileage.date, sum(dup.miles) from
> mileage, dup
> where
> dup.date <= mileage.date group by mileage.date, mileage.miles
> order by mileage.date;
Now that's a bit stupid. Why create this view when you can do the same
thing with a table alias (I'm I calling this by the right name?).
select m.miles, m.date, sum(d.miles) from mileage m, mileage d
where.......
Maarten
----------------------------------------------------------------- Visit our Internet site at
http://www.reuters.com
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.