[Quote=引用 11 楼 woshiliourun 的回复:]
引用 10 楼 bakhpl 的回复:
select a.学员编号,a.学员姓名,b.总成绩 from A left join (select
学员编号,sum(成绩)as 总成绩 from b group by 学员编号) as c on a.学员编号=c.学员编号
select * from (select a.*,b.成绩 as 成绩 from (select a.* ,b.*……
[/Quote] 同意!
select a.学员编号,a.学员姓名,b.总成绩 from A left join (select
学员编号,sum(成绩)as 总成绩 from b group by 学员编号) as c on a.学员编号=c.学员编号
select * from (select a.*,b.成绩 as 成绩 from (select a.* ,b.* from a inner join b on 1=1)as a
left join
b on a.学员编号=b.学员编号 and a.科目编号=b.科目编号) as tab where 成绩 is null