Re: SQL Help

[Suad Musovich]

> UPDATE SCRIPT Q_NODE_OCCUPANCY4 '  (select distinct count(volume_name) from 
>volumeusage where occupancy.node_name = volumeusage.node_name) as NUMBER_OF_TAPES -'

Haven't figured it out yet, but your sub-query is incorrect.

You want;
    select count(distinct volume_name) from ....

Cheers, Suad
--