search results from 2 tables

I have a search script that I would like to search thru 2 tables and not just the one as it does not what is the best way to do this. As my script stands know it looks like this
    strSQL = \"SELECT * FROM listall WHERE\"
    strSQL = strSQL & \" ( name LIKE \'%\" & strKeyword & \"%\')\"
    strSQL = strSQL & \" OR (descript LIKE \'%\" & strKeyword & \"%\')\"
    strSQL = strSQL & \" OR (info LIKE \'%\" & strKeyword & \"%\')\"
    strSQL = strSQL & \" OR (example LIKE \'%\" & strKeyword & \"%\')\"

    strDSN = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\"&Server.MapPath(\"../db/media.mdb\")
    Set myConn = Server.CreateObject(\"ADODB.Connection\")
    myConn.Open strDSN

    Set rs = myConn.Execute(strSQL)
    If Not (rs.BOF Or rs.EOF) Then

    Do While Not rs.EOF
        Response.Write \"<tr><td valign=top align=left rowspan=2><a href=vis_data_alt.asp?id=\" & rs(\"Id\") & \" ><img border=0 width=17 height=17 src=icons/ret.gif alt= Læs&nbsp;mere&nbsp;om&nbsp;\" & rs(\"name\") & \" ></a></td><td width=520 valign=top align=left><b><a href=vis_data_alt.asp?id=\" & rs(\"Id\") & \" > \" & rs(\"name\") & \" </a></b></td></tr>\"
        Response.Write \"<tr><td id=td_noborder_color> \" & rs(\"info\") & \"<br><br></td></tr>\"
        rs.MoveNext
    Loop

I changed
    strSQL = \"SELECT * FROM listall WHERE\"
to
    strSQL = \"SELECT * FROM listall, articals WHERE\"
articals is the other table, this of course doesnt work but am I on the right track ??
And how would one call the other columes from the other table ?? I have seen the question here on Eksperten before but just cant seem to find it
Any help would be great
//Guzzie