???????????????JDBC?????????????????????

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};
????????????
??????????????????JDBC??????????????????????????????
JDBC?????????????????????
LIKE??????JDBC?????????????????????
fn???????????????????????????JDBC?????????????????????
???????????????JDBC?????????????????????
???????????????JDBC?????????????????????
??????????????????????????????JDBC?????????????????????