（oracle）数据库中表的连接演示

（oracle）数据库中表的连接演示

select * from "name_info";

select * from "work_info";

-- 内连接只显示满足on条件的 SELECT * from "name_info" n inner join "work_info" w on n."id" = w."deptno";

SELECT * from "name_info" n , "work_info" w where  n."id" = w."deptno";

-- 左链接，左边的表全部显示，右边的表只显示满足 on 条件的 SELECT * from "name_info" n left join "work_info" w on n."id" = w."deptno";

SELECT * from "name_info" n , "work_info" w where  n."id" = w."deptno"(+);

-- 右链接，右边的表显示全，左边的表只显示满足on条件的 SELECT * from "name_info" n right join "work_info" w on n."id" = w."deptno";

SELECT * from "name_info" n , "work_info" w where  n."id"(+) = w."deptno";

-- 全外链接

SELECT * from "name_info" n full join "work_info" w on n."id" = w."deptno";