There are a couple of ways that you can handle this depending on what you want to do with the results. Probably the most common is to use a CTE with a ROW_NUMBER to either filter out or delete the duplicate rows.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA