--没有主外键关联的话,查询结果是笛卡尔积 完全的拼接
select e.*,d.* from emp e, dept d
--主外键关联
select e.*,d.* from emp e, dept d where e.deptno = d.deptno;
select e.*,d.* from emp e inner join dept d on e.deptno = d.deptno;
--多表联合
select ,,,, from a,b where a.bid = b.bid;
select ,,,, from a,b,c where a.bid = b.bid and b.cid = c.cid;
select ,,,,, from a,b,c,d where a.bid = b.bid and b.cid = c.cid and d.did ;