FROMãè¡¨ï¼ LEFT|RIGHTãOUTER JOIN è¡¨ï¼ ON ï¼ è¡¨ï¼.åA = 表ï¼.åA ï¼ ANSI/ISO SQL99ã«å¯¾å¿ããå¤é¨çµå LEFT OPUTER JOINã¨æå®ããå ´åã¯ã表ï¼ã®åAã«ããåå¨ããªããã¼ã¿ãæ¤ç´¢ããã RIGTH OPUTER JOINãæå®ããå ´åã¯ã表ï¼ã®åAã«ããåå¨ããªããã¼ã¿ãæ¤ç´¢ããã SQL> select * from emp; EMP DEP JOB FIRST_NAME LAST_NAME SALARY --- --- ã--- ---------- ---------- ---------- E01 D01 ãJ01 ååï¼ ããããååï¼ ãããã100 E02 D01 ãJ01 ååï¼ ããããååï¼ ãããã250 E03 D02 ãJ02 ååï¼ ããããååï¼ ãããã200 E04 D02 ãJ03 ååï¼
{{#tags}}- {{label}}
{{/tags}}