สอบถามเกี่ยวกับการเชื่อม Access คับ.. The specified field 'IP' could refer to more than one table listed in the FROM

	Dim Conn,strSQL,objRec
	Set Conn = Server.Createobject("ADODB.Connection")
	Conn.Open "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("mydatabase.mdb"),"" , ""
	'*** Search By Name or Email ***'
	strSQL = "SELECT * FROM MyTable as a INNER JOIN Table1 as b on a.IP = b.IP  "
	strSQL = strSQL & "WHERE (IP LIKE '%"& Request.QueryString("txtKeyword") &"%' "
	strSQL = strSQL & "or Cill LIKE '%"& Request.QueryString("txtKeyword") &"%' ) "
	Set objRec = Server.CreateObject("ADODB.Recordset")
	objRec.Open strSQL, Conn, 1,3