¹ØÓÚORACLEÍâÁ¬½Ó£¨+£©

ÏÖÔÚÓÐÒÔÏÂÁ½ÕÅ±í£º
                                              ±íA Ô±¹¤£¨EMPLOYEE£©
  
EMP_NO
EMP_NAME
JOB
DEPT_NO
1
1
HXF
PRESIDENT
2
2
2
SCOTT
CLERK
1
3
3
SMITH
SALESMAN
3
4
4
JOHN
MANAGER
¡¡
                                                       
                                              ±íB ²¿ÃÅ£¨DEPARTMENT£©
  
DEPT_NO
DEPT_NAME
LOCATION
DEL_FLG
1
1
ACCOUNTING
HANGZHOU
0
2
2
RESEARCH
BEIJING
0
3
3
OPERATIONS
SHANGHAI
1
 
ÆäÖв¿ÃűíÖÐ×Ö¶ÎDEL_FLGΪ0±íʾ¸ÃÌõ¼Ç¼ÒÑɾ³ý£¬ÊÇÎÞЧ¼Ç¼£»·´Ö®Ïà·´¡£
 
Èç¹ûÐèÒªÕÒ³ö±íAÖеÄËùÓмǼ£¬²¢¹ØÁªÉϱíBÖеÄÓÐЧ¼Ç¼£¬ÎÒÃǺܿÉÄÜ»áд³öÒÔÏÂÈýÖÖSQLÓï¾ä£º
 
    Óï¾äÒ»£º
SELECT A.EMP_NAME, A.JOB, B.*
 from EMPLOYEE A, DEPTMENT B
 WHERE A.DEPT_NO = B.DEPT_NO(+)
   AND B.DEL_FLG(+) = '0'
¸ÃÓï¾äÀûÓÃOracleµÄÍâÁ¬½Ó·ûºÅ£¬²¢ÓÃÌõ¼þB.DEL_FLG(+) = '0'ÏÞ¶¨±íBÖÖµÄÓÐЧ¼Ç¼¡£Ò²ÓÐÈË¿ÉÄÜ»áд³ÉÓï¾ä¶þ£º
     Óï¾ä¶þ£º
SELECT A.EMP_NAME, A.JOB, B.*
 from EMPLOYEE A, DEPTMENT B
 WHERE A.DEPT_NO = B.DEPT_NO(+)
   AND B.DEL_FLG = '0'
Óï¾ä¶þÖбíBÖеÄ×Ö¶ÎDEL_FlGû´øÍâÁ¬½Ó·ûºÅ¡£»¹ÓÐÖÖд·¨£¬ÈçÓï¾äÈý£º
    Óï¾äÈý£º
SELECT *
 from (SELECT A.EMP_NAME