Use the following select statement: select * from backupsets, volhistory where backupsets.date_time = volhistory.date_time
Joerg Pohlmann 604-535-0452 Kevin Godfrey <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-02-03 07:41 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: Backupset Hi How can one see which volumes belong to a particular backupset? Thanks Kevin