Oracle Á¬½Ó ¸´Ï°

SQL> select * from ta;
        ID NAME
---------- --------------------
         1 gorey
         2 gorey2
SQL> select * from tb;
        ID ADDRESS
---------- --------------------
         2 g2
         3 g3
SQL>
¡ñ×óÍâÁ¬½Ó -¡· ×ó±í¼Ç¼ȫ²¿Ñ¡ÖУ¬ÓÒ±íÆ¥ÅäÑ¡ÖÐ £¬Î´Æ¥ÅäµÄÇé¿öNULLÏÔʾ
SQL> select * from ta left outer join tb on ta.id = tb.id;
        ID NAME                         ID ADDRESS
---------- -------------------- ---------- --------------------
         1 gorey
         2 gorey2                        2 g2
SQL> select * from ta left join tb on ta.id = tb.id;
        ID NAME                         ID ADDRESS
---------- -------------------- ---------- --------------------
         1 gorey
         2 gorey2                        2 g2
SQL> select * from ta,tb where ta.id = tb.id(+);
        ID NAME                         ID ADDRESS
---------- ------------