I have a program in SQL plus that is currently duplicating. I beleive i need to add a distinct. I currently have a distinct at the beginning of my select, but i need to another distinct somewhere in the middle. how do i do multiple distincts. I.E;
select distinct 'ver12345', a.ssn_id, b.ssn_id, (I need a distinct at this point,)a.last_name.
August 11, 2005 8:12 AM
August 17, 2005 6:44 PM