在access中運行下列的sql語句會出現 查詢運算式中b.ressoc1 from cmsoc as b 中的語法錯誤(少了運算元) update reportuser_mtmember as a set a.m_address = b.ressoc1 from cmsoc as b where a.m_cardnum = b.numsoc

您好﹗    檢查一下是否有漏寫空格之類的﹒ 或者把SQL改為如下試試﹕ Update reportuser_mtmember a, cmsoc b Set a.m_address=b.ressoc1 where a.m_cardum=b.numsoc    ================================= 有空來瞅瞅我﹗因為我是您的朋友﹐有您真好﹗ ================================

------
忻晟

檢查沒有漏空格, 按照你的方法就ok了。 謝謝!    

引言: 您好﹗ 檢查一下是否有漏寫空格之類的﹒ 或者把SQL改為如下試試﹕ Update reportuser_mtmember a, cmsoc b Set a.m_address=b.ressoc1 where a.m_cardum=b.numsoc ================================= 有空來瞅瞅我﹗因為我是您的朋友﹐有您真好﹗ ================================