Auditocc = select node_name, sum(physical_mb) from occupancy group by
node_name

occupancy = select * from occupancy where ......
          = select node_ame, filespace_name, sum(physical_mb) from occupancy
group by node_name, filespace_name

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail