以前的写法:
SELECT stu.*, sc.C,sc.score FROM student stu,sc sc1,sc sc2,sc sc
WHERE stu.S = sc.s AND stu.S = sc1.S AND stu.S = sc2.S
AND sc1.C = '01' AND sc2.C = '02' AND sc1.score > sc2.score
现在的写法:
left join sc sc on stu.S = sc.s --19 2^4+3
left join sc sc1 on stu.S = sc1.s --AND sc1.C = '01' -49 2^5 +17
left join sc sc2 on stu.S = sc2.s -- AND sc2.C = '02' --133
where sc1.C = '01' AND sc2.C = '02' AND sc1.score > sc2.score
select * from student
select * from sc
1 2 3 4 4*3 12 4*9 36 4*27 108
5 6 7 3*2 6 3*4 12 3*8 24
8 1*1 1*1 1 1*1 1