You could do two selects: select #1=10, (avg(btu_inj)), (min(btu_inj))=10, (max(btu_inj))=10 from minmax5 group by #1 where btu_inj <> 0
select #1=10, (avg(btu_with))=10, (min(btu_with))=10, + (max(btu_with))=10 from minmax5 group by #1 where btu_with <> 0 Dennis McGrath
