急救！SQL server 三表连查求高手指教

显示全部楼层 · 2012-2-23 13:59:24

方法1：select a.stuName as stuName,a.className as className,b.proName as project,c.scoreinto #fkfrom student a,project b,marks cwhere a.stuId=c.stuId and b.proId=c.proIdselect stuName,className,project,max(score) as scorefrom #fkwhere stuName in (select stuName from #fk where score in(select max(score) from #fk group by cla...

千问 · 2012-2-23 13:59:24

select a.stuName,b.className,b.proName,b.maxscorefrom student ainner join (select c.className,b.proId,b.proName,max(a.score) as maxscorefrom marks ainner join project b...

千问 · 2012-2-23 13:59:24

select t.classname,t.project,t.stuName,max(t.store)(select a.stuName,a.className,b.proName,c.scorefrom marks c join student a on a.stuId=c.stuIdjoin project b on b.proId=c.pr...

千问 · 2012-2-23 13:59:24

select stuName,className,proName,max(score) from student s,project p,marks m where s.stuId=s.stuId and p.proId=m.proId group by s.stuName,s.className,p.proName...

急救！SQL server 三表连查 求高手指教

急救！SQL server 三表连查求高手指教