select distinct a.课程名称 as 学位课程,a.成绩,a.学分, b.课程名称 as 非学位课程,b.成绩,b.学分 from vb as a inner join vb as b on a.学位否=1 and b.学位否=2 where b.成绩 is not null and a.成绩 is not null
写少条件了吧???select distinct a.课程名称 as 学位课程,a.成绩,a.学分, b.课程名称 as 非学位课程,b.成绩,b.学分 from vd as a inner join vd as b on a.学号=b.学号 and a.学位否=1 and b.学位否=2 and a.成绩 is not null and b.成绩 is not null where a.学号=004
select distinct a.课程名称 as 学位课程,a.成绩,a.学分, b.课程名称 as 非学位课程,b.成绩,b.学分 from vd as a inner join vd as b on a.学号=b.学号 and a.学位否=1 and b.学位否=2 and a.成绩 is not null and b.成绩 is not null where a.学号=004
from vd as a inner join vd as b on a.学号=b.学号 and a.学位否=1 and b.学位否=2 and a.成绩 is not null and b.成绩 is not null
where a.学号=004
b.课程名称 as 非学位课程,b.成绩,b.学分
from vd as a
inner join vd as b
on a.学号=b.学号 and a.学位否=1 and b.学位否=2 and a.成绩 is not null and b.成绩 is not null
where a.学号=004