SELECT    MediaId,VolumeName,Slot,PoolId,
          MediaType,FirstWritten,LastWritten,LabelDate,VolJobs,
          VolFiles,VolBlocks,VolMounts,VolBytes,VolErrors,VolWrites,
          VolCapacityBytes,VolStatus,Enabled,Recycle,VolRetention,
          VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,InChanger,
          EndFile,EndBlock,LabelType,StorageId,DeviceId,
          LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,
          Comment,Name AS Storage
FROM      Media
LEFT JOIN Storage USING(StorageId)

