1234567891011121314151617181920212223select PHONE from ( select replace(replace(PHONE,'-',''),' ', '') as PHONE from TB_SIGNATURE where RMV_YN = 'Y' union all select replace(replace(PHONE,'-',''),' ', '') as PHONE from TB_SHOT where RMV_YN = 'Y' ) A group by PHONE having isNull(PHONE,'') != '' order by PHONEColored by Color Scriptercs