Re: Joining BACKUPS and CONTENTS tables.

[Richard Sims]

>You cannot differentiate between ACTIVE and INACTIVE in the CONTENTS table,
>so that if you had three versions in the BACKUPS table, you would match each
>of these three times in the contents table...

Paul - In the BACKUPS table, a null value for the DEACTIVATE_DATE column
       indicates that the file is the Active copy, and a date value
indicates an Inactive copy, if that helps.
   Richard Sims, BU