ASP高手請看...(編號:4680)

請問以下的程式 為何會出現這樣的錯誤訊息呢
難道Access2000不支援 JOIN 的語法嗎?
----------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers 錯誤 '80004005'
[Microsoft][ODBC Microsoft Access 驅動程式] 不支援結合運算式。
/test.asp, 列29
----------------------------------------------------------

<!--#include file="adovbs.inc"-->
<%
DBPath = Server.MapPath("/test.mdb")
  sql = "[topic_A]"
 
  Set TPC_conn = Server.CreateObject("ADODB.Connection")
  TPC_conn.Open "driver={Microsoft Access driver (*.mdb)};dbq=" & DBPath     
 
  Set TPC_A_rs = Server.CreateObject("ADODB.Recordset")
  TPC_A_rs.Open sql,TPC_conn,adOpenStatic,adLockReadOnly 
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>分類項目管理</title>
</head>
<center>
<%
   Do While Not TPC_A_rs.EOF    
    
    sql = "Select topic_A.TPC_A , topic_B.TPC_B , topic_B.TPC_B_Name , topic_B.TPC_A " & _
       "From topic_A Left Join topic_B " & _
       "ON topic_B.TPC_B = " & TPC_A_rs("TPC_A")          
    
    Set TPC_B_rs = Server.CreateObject("ADODB.Recordset")
    TPC_B_rs.Open sql,TPC_conn,adOpenDynamic,adLockPessimistic    
    
    
    TPC_A_rs.MoveNext
   Loop
  %> 
</center>
</html>