这句查询语句错在哪里？为什么总是不能执行？提示into附近有错误！

[jethao]

有一张记录表<T1>,内有<人员代码>、<姓名>、<记录日期>字段，现在我想找到查到每个人员的“记录日期为最新”的记录：

select yhdm as 用户代码, yhmc as 用户名称,kprq as 开票日期
from t1,(select yhdm,max(kprq) as kprq ) into T1 from t1 group by yhdm
where t1.yhdm = T2.yhdm

[pengdali]

select yhdm as 用户代码, yhmc as 用户名称,kprq as 开票日期
from t1,(select yhdm,max(kprq) as kprq ) T1 from t1 group by yhdm
where t1.yhdm = T2.yhdm

[pengdali]

select yhdm as 用户代码, yhmc as 用户名称,kprq as 开票日期
from t1,(select yhdm,max(kprq) as kprq ) T2 from t1 group by yhdm
where t1.yhdm = T2.yhdm

[XLYT]

select yhdm,max(kprq) as kprq后面没有from了？

[caiyunxia]

select yhdm as 用户代码, yhmc as 用户名称,kprq as 开票日期
from t1,(select yhdm,max(kprq) as kprq FROM T1 GROUP BY YHDM) T2
where t1.yhdm = T2.yhdm

[pae]

into 写在 from 之前

怎么能有两个from呢？ 你应该仔细看看sql语法了

[pengdali]

哦！呀！我都看错了！呵呵！

select yhdm as 用户代码, yhmc as 用户名称,max(kprq) as 开票日期
from t1 group by yhdm,yhmc