你怎么俩table1,后一个叫table2吧
执行以下语句
select t1.考试学号,t1.科目,t2.考试成绩
from
(select a.科目,a.科目ID,b.考试学号
from
(select 科目,科目ID from table1) as a,
(select distinct 考试学号 from table2) as b) as t1 left join
table2 as t2 on t1.科目ID=t2.科目ID and t1.考试学号=t2.考试学号
结果截图
下边还有几条没显示全,凑合看吧
追问这位大哥,你的答案很好,我采纳的时候点错了。我百度了下,也不可以修改了,不好意思哈,谢谢了。
追答这位小弟,要不你再问一次,要不我多委屈