join edu on [user].userid=edu.userid
join (select userid,max(DEGREE) as degree from edu group by userid )edu on [user].userid=edu.userid
会好不?
join (select userid,max(DEGREE) as degree from edu group by userid )edu on [user].userid=edu.userid
会好不?
FROM (
SELECT [USER].USERID,[USER].[NAME],MAX(edu.degree)degree
FROM [USER]
JOIN edu ON [USER].USERID=edu.USERID
GROUP BY [USER].USERID,[USER].[NAME]
)A
JOIN work B ON A.USERID = B.USERID别忘了加索引
join edu on [user].userid=edu.userid
join (select userid,max(DEGREE) as degree from edu group by userid )edu on [user].userid=edu.userid
竟然不行,提示列名 '' 无效。