Hjælp til noget kode :)

Hej.. Jeg skal i dette kode stykke ha hentet Username fra en anden tabel ( Bruger ) som er lig med User_id i ( Mestbl )

Do While iRecordsShown < iPageSize And Not RS.EOF
    SQL = \"SELECT Count(*) AS ItemCount FROM MesTbl WHERE (Thread_id = \" & rs(\"Id\") & \")\"
    Set recordCount = Conn.Execute(SQL)   
    tid=rs(\"thread_id\")
    ParentID=rs(\"id\")
    name=rs(\"name\")
    email=rs(\"email\")
    subject=rs(\"subject\")
    mesdate=rs(\"mesdate\")
    response.write \"<tr><td width=\'40%\' bgcolor=\'#DFC089\'><font face=\'Verdana, Tahoma, Arial, Helvetica\' color=\'#404040\' size=\'1\'><strong>\"
    response.write \"<a href=\'show.asp?id=\" & parentID & \"&fid=\"&fid&\"&tid=\"&tid&\"\'>\" & subject & \"</a></td><td width=\'25%\' bgcolor=\'#DFC089\'><font face=Verdana, Tahoma, Arial, Helvetica size=1 color=#404040><b>\" & name & \"</B></a>&nbsp;&nbsp;<a href=\'forfatterinfo.asp?biD=\" & email & \"\'><img src=\'http://www.boykot.dk/images/info.gif\' border=\'0\'></a></td><td width=\'10%\' bgcolor=\'#DFC089\'><font face=\'Verdana, Tahoma, Arial, Helvetica\' color=\'#404040\' size=\'1\'><center>\" & recordCount(\"ItemCount\") & \"</td><td width=\'20%\' bgcolor=\'#DFC089\'><font face=\'Verdana, Tahoma, Arial, Helvetica\' color=\'#404040\' size=\'1\'>\" & mesdate & \"\"
    response.write \"</tr></td>\"
    \'calling procedure to show childs
    rs.movenext
    iRecordsShown = iRecordsShown+1
    loop

Dvs. istedet for at hente name fra (mestbl), skal den hente Username fra (Bruger)..

Hvorn?