老师,下面这段代码运行时出现 ‘列名 'partid' 不明确。’,问题出在哪啦
cmd.CommandText = "S elect * From (S elect Row_Number() Over(Order by part.partId desc ) As RowNum,part.partId,partNo,mouldId,gelcoatColor,backColor,thickness,area,size,drawingNo,remark,thickness2" & _
" From part Left JOIN testResultMaster ON testResultMaster.partId = part.partId " & iif(Filter > "", " Where " & Filter ,"") & _
" Group By {part}.partId,partNo,drawingNo) As a Where RowNum >= " & StartRow & " And RowNum <= " & EndRow