Re: SQL Help
2001-02-05 00:24:41
> 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
--
=========================================================================
|
|
|