• That's your answer. Account_id is the primary key. It is already unique. The use of distinct will produce the same number of rows as the query without it.

    If you are trying to make performance better, try using EXISTS or a simple inner join.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/