SQL中内连接和外连接区别
弄个例题,直观一点。两个表:--表stu
id name 1, Jack2, Tom3, Kity4, nono--表examid grade1, 562, 7611, 89内连接 (显示两表id匹配的)select stu.id,exam.id,stu.name, exam.grade from stu
inner join exam on stu.id=exam.idstu.id exa
转载
2014-11-12 20:06:17 ·
545 阅读 ·
0 评论