SQL語法問題

版主好:
依據_版主補充的說明_那就直接使用_EXL_來做回答

假設_表A_資料_放在_Sheet5___表B__放在_Sheet4

試試下列_

S1 = "SELECT IIf(Count(K.ID)=1,M.ID,"""") AS NewID, IIf(Count(K.ID)=1,M.NAME,"""") AS NAME2, M.CODE, M.COUNT" & _
" FROM (SELECT [Sheet4$].*, [Sheet5$].NAME FROM [Sheet4$] INNER JOIN [Sheet5$] ON [Sheet5$].ID = [Sheet4$].ID) M," & _
"(SELECT [Sheet4$].* FROM [Sheet4$]) K" & _
" WHERE M.CODE >= K.CODE And M.ID = K.ID" & _
" GROUP BY M.ID, M.NAME, M.CODE, M.COUNT, M.ID, M.CODE" & _
" ORDER BY M.ID, M.CODE ASC;"

S1_如何使用_依版主實際需要做設定.

To 版主大大
NAME,COUNT兩欄在Excel均造成錯誤
不知版大是查詢何檔
在Excel查詢外在Excel檔在更改欄名
CNAME,CCOUNT後可正確匯入
敘述如下
"Select o.ID, p.CNAME, o.CODE, o.CCOUNT " & _
"from [Sheet2$] as o left outer join [Sheet1$] as p " & _
"on o.ID = p.ID"
版主試試可否執行