SELECT    MediaId,VolumeName,VolStatus,Enabled,
          VolBytes,VolFiles,VolRetention,Recycle,Slot,InChanger,
          MediaType,LastWritten,Name AS Storage,
          CASE WHEN COALESCE(Media.EncryptionKey, '') = ''
               THEN 0
               ELSE 1
          END AS HasEncryptionKey
FROM      Media
LEFT JOIN Storage USING(StorageId)
