[凡鸽鸽]《课内学习07》MYSQL 实验7 多表连接查询1

课内学习07 — MYSQL

实验7 多表连接查询1源码如下：

1.
create database xscj;
2.
use xscj;
3.
source C:\Users\Administrator\Desktop\sy81.sql
4.
create database yggl;
5.
use yggl;
6.
source C:\Users\Administrator\Desktop\sy82.sql
7.
select 学号,姓名,课程号,成绩 from xs_kc join xs using (学号) where 课程号 = '101' and 成绩 >= 80;
8.
select 学号,姓名,课程号,成绩 from xs join xs_kc using (学号);
9.
select kc.课程号,课程名,成绩 from kc,xs_kc where kc.课程号 = xs_kc.课程号;
10.
use yggl;
11.
select salary.编号,姓名,收入-支出 as 工资 from employees join salary using (编号); 
12.
select 编号,姓名,部门名称 from departments join employees using(部门号) where 姓名 = '王林';