Derbyã?¯å¤–部çµ?å?ˆ(ã?Šã‚ˆã?³å…¨çµ?å?ˆ)ã?®JDBCエスケープ構文をã€?ç‰ä¾¡ã?ªå¤–部çµ?å?ˆã‚‚ã?—ã??ã?¯é?©åˆ‡ã?ªç¨®é¡žã?®çµ?å?ˆã?®SQLæ§‹æ–‡ã?¸ã?¨è§£é‡ˆã?—ã?¾ã?™ã€‚
å?„種ã?®çµ?å?ˆã?«ã?¤ã?„ã?¦ã?¯ã€?JOIN 演算をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。
{oj ��処� [��処� ]* }
��処� [��処� ]*
-- 外部çµ?å?ˆ SELECT * FROM {oj Countries LEFT OUTER JOIN Cities ON (Countries.country_ISO_code=Cities.country_ISO_code)} -- ä»–ã?®çµ?å?ˆå‡¦ç?† SELECT * FROM {oj Countries JOIN Cities ON (Countries.country_ISO_code=Cities.country_ISO_code)} -- 表å¼?ã?¯çµ?å?ˆå¼?ã?§ã‚‚ã?‹ã?¾ã‚?ã?ªã?„ã?®ã?§ã€? -- FROMå?¥ã?«è¤‡æ•°ã?®çµ?å?ˆå‡¦ç?†ã‚’記述ã?§ã??ã?¾ã?™ã€‚ SELECT E.EMPNO, E.LASTNAME, M.EMPNO, M.LASTNAME FROM {oj EMPLOYEE E INNER JOIN DEPARTMENT INNER JOIN EMPLOYEE M ON MGRNO = M.EMPNO ON E.WORKDEPT = DEPTNO};