sql select 使用问题

Question

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)我应该怎么改，这样改是错的