How to select the records without duplicating form inner join tables
<p>From this query how can I get the records without duplicate value.
I need to get the values, if the name from the table a and account from the table c should view when the dates field is maximum. </p>

<pre><code>SELECT
      a.name
    , a.dates
    , b.da
    , a.id
    , b.client
    , b.[Address]
    , b.[City]
    , b.[State]
    , b.dot
    , b.Score
    , b.Pay
    , b.code
    , b.[Country]
FROM a
INNER JOIN c ON a.Account = c.Account
INNER JOIN b ON [a].name = b.name
WHERE c.users = 00
    AND b.Act = 1
ORDER BY a.dates
</code></pre>