最最简单的SQL语句的SELECT问题!

Question

为什么我这句SQL在ACCESS里能用,在MSSQL里就不能用了呢?select S_ID_PSN,S_ID_POINT from (select distinct S_ID_PSN,S_ID_POINT  from 历史坐标表)

Answer 1

select S_ID_PSN,S_ID_POINT from (select distinct S_ID_PSN,S_ID_POINT  from 历史坐标表)a

Answer 2

select S_ID_PSN,S_ID_POINT from (select distinct S_ID_PSN,S_ID_POINT  from 历史坐标表) A对查找的结果再次查找时要加上一个别名 
后面加个A就行

Answer 3

缺少别名在“历史坐标表)”后加一别名 “a”-->历史坐标表) a

Answer 4

select S_ID_PSN,S_ID_POINT from (select distinct S_ID_PSN,S_ID_POINT  from 历史坐标表) t

Answer 5

select S_ID_PSN,S_ID_POINT from (select distinct S_ID_PSN,S_ID_POINT  from 历史坐标表) a --取个别名a