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"
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(4) 人氣()