搜题
问题   更新时间2023/4/3 12:59:00

[计算题,3.7分] 有二个数据表XS(xh, xm)和XS_KC(xh, kch, cj),用两种方法,写出如下查询:“查找数据库中所有学生的学号(xh)、姓名(xm)以及其所选修的课程号(kch)和成绩(cj)”。

(1) select xs.xh,xm,kch,cj from xs, xs_kc where xs.xh=xs_kc.xh; (2) select xs.xh,xm,kch,cj from xs join xs_kc on xs.xh=xs_kc.xh;
王老师:19139051760(拨打)