請問以下的程式 為何會出現這樣的錯誤訊息呢
難道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＞