queryStr = "SELECT B.TRAM_STOP_ID, B.ENG_LOCATION, B.VER FROM (SELECT TRAM_STOP_ID, VER From " _
& tabName & " where FEATUREID is null ) as A, " & tabName & " as B" _
& " Where A.Tram_Stop_ID = B.Tram_Stop_ID AND A.VER = B.VER AND B.STS = 'I'"请高手指点下!先谢过了!!
& tabName & " where FEATUREID is null ) as A, " & tabName & " as B" _
& " Where A.Tram_Stop_ID = B.Tram_Stop_ID AND A.VER = B.VER AND B.STS = 'I'"请高手指点下!先谢过了!!
FROM (SELECT TRAM_STOP_ID, VER From " & tabName & " where FEATUREID is null ) as A, "
& tabName & " as B " & "
Where A.Tram_Stop_ID = B.Tram_Stop_ID AND A.VER = B.VER AND B.STS = 'I'
========================================
子查询,得考虑类型匹配问题!!
(SELECT TRAM_STOP_ID, VER From " & tabName & " where FEATUREID is null ) 的返回值是一个表名吗?
这个条件似乎是成立的 总是是报sql语句未正常结束,恳请高手赐教啊!!