>select max(Master_ind) as Master_Ind, Master_Code, count(*) as RecCount from myTable T1 >where Master_Ind = 'Y' or not exists(select 1 from myTable T where T.Master_Code = T1.Master_Code and Master_Ind = 'Y') >group by Master_CodeHow would this do what he wants? Even if it did (I don't think it would but thinking if it were right) then can you really have an updateable view out of this???