两张表,一张表(tbemp)存放员工的信息,包括工资;一张表(tbsal)存放工资级别。表结构如下:
tbemp:
tbsql:
查询语句及其结果:
SQL:
SELECT a.*,b.`level` FROM tbemp a,tbsal b WHERE a.sal BETWEEN b.`start` AND b.`end`;
两张表,一张表(tbemp)存放员工的信息,包括工资;一张表(tbsal)存放工资级别。表结构如下:
tbemp:
tbsql:
查询语句及其结果:
SQL:
SELECT a.*,b.`level` FROM tbemp a,tbsal b WHERE a.sal BETWEEN b.`start` AND b.`end`;