usofa, if there are 100000 of row, how would you know only 'B' & 'C' id have distinct values in bill_career? The logic wouldn't work. Just my two cents.