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