Re: car mileage summation / sledgehammer method

> 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.