SLQstr = "SELECT toPost.seq, myBoard.name AS BoardName, toPost.Title , toPost.body " & _
"FROM toPost INNER JOIN " & _
"myBoard ON myBoard.SEQ = toPost.boardID INNER JOIN " & _
"users ON users.seq = toPost.userID"
可否幫我看一下,這樣的語法,執行時的錯誤訊息是:
查詢運算式'myBoard.SEQ = toPost.boardID INNER JOIN users ON users.seq = toPost.userID'中的語法錯誤(少了運算元)
但是如果這樣設又正常:
SLQstr = "SELECT toPost.seq, myBoard.name AS BoardName, toPost.Title , toPost.body " & _
"FROM toPost INNER JOIN " & _
"myBoard ON myBoard.SEQ = toPost.boardID"
"FROM toPost INNER JOIN " & _
"myBoard ON myBoard.SEQ = toPost.boardID INNER JOIN " & _
"users ON users.seq = toPost.userID"
可否幫我看一下,這樣的語法,執行時的錯誤訊息是:
查詢運算式'myBoard.SEQ = toPost.boardID INNER JOIN users ON users.seq = toPost.userID'中的語法錯誤(少了運算元)
但是如果這樣設又正常:
SLQstr = "SELECT toPost.seq, myBoard.name AS BoardName, toPost.Title , toPost.body " & _
"FROM toPost INNER JOIN " & _
"myBoard ON myBoard.SEQ = toPost.boardID"
全站熱搜
留言列表