- query = "SELECT mediatype AS MediaType, pool.name AS PoolName"
- " FROM media"
- " LEFT OUTER JOIN pool ON media.poolid = pool.poolid"
- " WHERE volumename = \'" + m_fromVolume + "\'";
+ query = "SELECT MediaType AS MediaType, Pool.Name AS PoolName"
+ " FROM Media"
+ " LEFT OUTER JOIN Pool ON Media.PoolId = Pool.PoolId"
+ " WHERE VolumeName = \'" + m_fromVolume + "\'";