ON å¥ã¯çµåˆæ¡ä»¶ã€WHERE å¥ã¯æŠ½å‡ºæ¡ä»¶ - 集ä¸åŠ›ãªã‚‰å£²ã‚Šåˆ‡ã‚ŒãŸã‚ˆON å¥ ã¯ çµåˆã™ã‚‹ãŸã‚ã®æ¡ä»¶ã§ã€ŒXXX ã®å ´åˆã ã‘ XXX ã¨ãã£ã¤ã‘ã¦ã€ã¨ã„ã†æ„味。 WHERE å¥ã¯ FROM å¥ã®çµåˆãŒã™ã¹ã¦çµ‚ã‚ã£ãŸå¾Œã®ã€æŠ½å‡ºã™ã‚‹æ¡ä»¶ã€‚ SQL SELECT e.emp_no, e.emp_name, d.dept_no, d.dept_name FROM emp e LEFT OUTER JOIN dept d ON e.dept_id = d.id AND d.dept_no = '20' ORDER BY e.emp_no çµæžœ EMP_NO EMP_NAME DEPT_NO DEPT_NAME 7369 SMITH 20 RESEARCH 7499 ALLEN null null 7521 WARD null null 7566 JONES 20 RESEARCH 7654 MARTIN null null 7698 BLAKE null null 7
{{#tags}}- {{label}}
{{/tags}}