Hello, thanks for your answer.
What I would like, if possible, is something on the line of "SELECT
DISTINCT ON file ..... WHERE date NOT GREATER THAN somedate [ORDER BY
date desc]" but cannot seem to find a way to do it.
I would greatly appreciate any ideas on this subject, kind regards to all,
Barbara F.
Would it be possible to post the setup in terms of sql queries?
Chetan Sutrave
http://www.enterprisedb.com
-- Dra. Bárbara M. Figueirido 25 de Mayo 1331 8400 S.C. de Bariloche - RIO NEGRO Argentina Tel.-Fax: +54 2944 456252 15682745