select a.code,name from a join b on a.code=b.code where course<>'Cl02'select a.code,name from a表 as a join b表 as b on a.code=b.code where grade=(select max(grade) from b表 where course='C2' and code=a.code)
改正一下:select a.code,name from a join b on a.code=b.code where course<>'Cl02'select a.code,name from a表 as a join b表 as b on a.code=b.code where grade=(select max(grade) from b表 where course='C2')
1,select * from a where code not in (select code from b where course='C102')2,select * from a code in (select top 1 code from b where course='C2' order by grade desc)
1,select * from a where code not in (select code from b where course='C102')2,select * from a code in (select top 1 code from b where course='C2' order by grade desc)