Data displayed multiple times but only want some of it displayed

I have a query that returns data based on an INNER JOIN. It is for consultations so most data is static e.g. Name etc but some data, Notes taken from the consultations, get updated and this query is supposed to displaya ll the consultation data but because the notes have been updated several times it is displaying all the other data several times too when it only needs to be displayed once.
QUERY:
sql = "SELECT c.uid, c.projectTitle, c.consultant, c.c_where, c.c_when, n.notes, n.project FROM consultation_info AS c INNER JOIN Notes AS n ON c.projectTitle = n.project ORDER BY consultant ASC"

CODE TO DISPLAY DATA IS AS FOLLOWS -
    Response.Write ("<tr>")
    Response.Write ("<td>"&Rs1("consultant")&"</td>")
    Response.Write ("<td>"&Rs1("projectTitle")&"</td>")
      Response.Write ("<td>"&Rs1("c_where")&"</td>")
    Response.Write ("<td>"&Rs1("c_when")&"</td>")
      Response.Write ("<td>"&Rs1("notes")&"</td>")
      Rs1.MoveNext
Loop
else
   Response.Write("No records found")
end if
Response.Write "</table>"

DATA IS DISPLAYED AS FOLLOWS -
John | Pearson | Database | Testing | here | then | Hopefully this will work
John | Pearson | Database | Testing | here | then | again I hope this works

SHOULD BE LIKE -
Consultant projectTitle Where When Notes ID
John | Pearson | Database | Testing | here | then | Hopefully this will work
                                                                              | again I hope this works


Any help appreciated.
Start Free Trial