等值连接:select e.,d. from emp e,demp d where e.dno=d.dno 内连接:select e.,d. from emp e join demp d on e.dno=d.dno 外连接:select e.,d. from emp e left join demp d on e.dno=d.dno select e.,d. from emp e right join demp d on e.dno=d.dno 自连接:站在不同角度的查法
连表查询等值连接:select e.,d. from emp e,demp d where e.dno=d.dno内连接:select e.,d. from emp e join demp d on e.dno=d.dno外连接:select e.,d. from emp e left join demp d on e.dno=d.dnoselect e.,d. from emp e right join demp d on e.dno=d.dno自连接:站在不同角度的查法...