select id,name from user where id=1
这个查出来的是id=1的所有项目,
现在我把他改成
select
id,
name,
fs=(select top 1 nFinalScore from appname where id=u.id order by Date_Time desc),
ap=(select top 1 iApproveSign from appname where id=u.id order by Date_Time desc)
from user as u where id=1
这样运行,是可以查出FS和AP的值,
我想问问
把fs的改成这样
(select top 1 nFinalScore,iApproveSign from appname where id=u.id order by Date_Time desc)
我应该怎么改,这样改是错的
相关分类