> 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 --
- SQL Help Andrew Webster
- Re: sql help Suad Musovich
- Re: sql help Stapleton, Mark
- Re: sql help David E Ehresman
- Re: sql help Richard Sims
- Re: sql help Hooft, Jeroen
- sql help David E Ehresman
- Re: sql help Richard Sims
- SQL Help David E Ehresman
- Re: SQL Help James Choate
- Re: SQL Help David E Ehresman
- Re: SQL Help Stapleton, Mark