1.oracle中分不清楚左右链接的主表是哪个,与SQL999语法 左右链接不同
orale(左)外链接:select table1.column, table2.column
from table1, table2 -------table1为主表
where table1.column = table2.column(+);
orale(右)外链接:select table1.column, table2.column
from table1, table2 -------table2为主表
where table1.column (+)= table2.column;
SQL:1999语法(左)外链接: select table1.column, table2.column
from table1 left join table2 -------table1为主表
on table1.column= table2.column;
SQL:1999语法(左)外链接: select table1.column, table2.column
from table1 right join table2 -------table2为主表
oracle与SQL999语法中区分左右链接中那个是主表
最新推荐文章于 2022-05-19 11:10:59 发布