select m.* , n.* from tb m , tb n where m… = n…
SELECT m.stu_id,m.stu_name,result,cou_name FROM student m,score,course
WHERE score.stu_id=m.stu_id and score.cou_id=course.cou_id
ORDER BY stu_name
类似于把m赋值为student
select m.* , n.* from tb m , tb n where m… = n…
SELECT m.stu_id,m.stu_name,result,cou_name FROM student m,score,course
WHERE score.stu_id=m.stu_id and score.cou_id=course.cou_id
ORDER BY stu_name
类似于把m赋值为student