• If the above isn't possible you can always treat your current query as a subquery and do

    select distinct * from (subquery) A