多表查询sql语句.doc

多表?查询?sq?l语?句 ? 篇?一：? S?QL?语句?多表?查询?SQ?L语?句多?表查?询：? 问?题及?描述?： ?--? 1?.学?生表? S?tu?de?nt?(S?#,?Sn?am?e,?Sa?ge?,S?se?x)? -?-S?# ?学生?编号?,S?na?me? 学?生姓?名,?Sa?ge? 出?生年?月,?Ss?ex? 学?生性?别 ?--?2.?课程?表 ?Co?ur?se?(C?#,?Cn?am?e,?T#?) ?--?C#? -?-课?程编?号,?Cn?am?e ?课程?名称?,T?# ?教师?编号? -?-3?.教?师表? T?ea?ch?er?(T?#,?Tn?am?e)? -?-T?# ?教师?编号?,T?na?me? 教?师姓?名 ?--?4.?成绩?表 ?SC?(S?#,?C#?,s?co?re?) ?--?S#? 学?生编?号,?C#? 课?程编?号,?sc?or?e ?分数? *?/ ?--?创建?测试?数据? c?re?at?e ?ta?bl?e ?St?ud?en?t(?S#? v?ar?ch?ar? (?10?),?Sn?am?e ?nv?ar?ch?ar? (?10?),?Sa?ge? d?at?et?im?e,?Ss?ex? n?va?rc?ha?r ?(1?0)?) ?in?se?rt? i?nt?o ?St?ud?en?t ?va?lu?es?( ?01? ,? N? 赵?雷 ?, ?19?90?-0?1-?01? ,? N? 男? )? i?ns?er?t ?in?to? S?tu?de?nt? v?al?ue?s(? 0?2 ?, ?N ?钱电? ,? 1?99?0-?12?-2?1 ?, ?N ?男 ?) ?in?se?rt? i?nt?o ?St?ud?en?t ?va?lu?es?( ?03? ,? N? 孙?风 ?, ?19?90?-0?5-?20? ,? N? 男? )? i?ns?er?t ?in?to? S?tu?de?nt? v?al?ue?s(? 0?4 ?, ?N ?李云? ,? 1?99?0-?08?-0?6 ?, ?N ?男 ?) ?in?se?rt? i?nt?o ?St?ud?en?t ?va?lu?es?( ?05? ,? N? 周?梅 ?, ?19?91?-1?2-?01? ,? N? 女? )? i?ns?er?t ?in?to? S?tu?de?nt? v?al?ue?s(? 0?6 ?, ?N ?吴兰? ,? 1?99?2-?03?-0?1 ?, ?N ?女 ?) ?in?se?rt? i?nt?o ?St?ud?en?t ?va?lu?es?( ?07? ,? N? 郑?竹 ?, ?19?89?-0?7-?01? ,? N? 女? )? i?ns?er?t ?in?to? S?tu?de?nt? v?al?ue?s(? 0?8 ?, ?N ?王菊? ,? 1?99?0-?01?-2?0 ?, ?N ?女 ?) ?cr?ea?te? t?ab?le? C?ou?rs?e(?C#? v?ar?ch?ar? (?10?),?Cn?am?e ?nv?ar?ch?ar? (?10?),?T#? v?ar?ch?ar? (?10?))? i?ns?er?t ?in?to? C?ou?rs?e ?va?lu?es?( ?01? ,? N? 语?文 ?, ?02? )? i?ns?er?t ?in?to? C?ou?rs?e ?va?lu?es?( ?02? ,? N? 数?学 ?, ?01? )? i?ns?er?t ?in?to? C?ou?rs?e ?va?lu?es?( ?03? ,? N? 英?语 ?, ?03? )? c?re?at?e ?ta?bl?e ?Te?ac?he?r(?T#? v?ar?ch?ar? (?10?),?Tn?am?e ?nv?ar?ch?ar? (?10?))? i?ns?er?t ?in?to? T?ea?ch?er? v?al?ue?s(? 0?1 ?, ?N ?张三? )? i?ns?er?t ?in?to? T?ea?ch?er? v?al?ue?s(? 0?2 ?, ?N ?李四? )? i?ns?er?t ?in?to? T?ea?ch?er? v?al?ue?s(? 0?3 ?, ?N ?王五? )? c?re?at?e ?ta?bl?e ?SC?(S?# ?va?rc?ha?r ?(1?0)?,C?# ?va?rc?ha?r ?(1?0)?,s?co?re? d?ec?im?al?(1?8,?1)?) ?in?se?rt? i?nt?o ?SC? v?al?ue?s(? 0?1 ?, ?01