Tom,
> Oh, I'm sorry: forgot the extra qualification on the innermost SELECT:
>
> AND oldest.timestamp < history.timestamp
Hmmm ... I'll try both solutions tommorrow. That is, I'll see if they portacross databases ...
> > Yeah, you guessed it ... MS SQL Server 7.
>
> I dunno, how good is SQL Server on subselects?
Not very good. A lot of stuff, like subselects in the SELECT line, is notsupported. And MS has gotten further from
theSQL standard with each updatesince SQL Server 7.0 ...
-Josh
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco