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)我應該怎么改,這樣改是錯的
sql select 使用問題
千萬里不及你
2018-09-05 17:17:26