SELECT E.EMPLOYEE_ID, E.LAST_NAME, D.DEPARTMENT_ID, D.DEPARTMENT_NAME FROM HR.EMPLOYEES E LEFT OUTER JOIN HR.DEPARTMENTS D ON E.DEPARTMENT_ID = D.DEPARTMENT_ID SELECT E.EMPLOYEE_ID, E.LAST_NAME, D.DEPARTMENT_ID, D.DEPARTMENT_NAME FROM HR.EMPLOYEES E ,HR.DEPARTMENTS D WHERE E.DEPARTMENT_ID= D.DEPARTM    Read More
posted @ 2011-08-07 12:06
庚武
Views(353)
Comments(0)
Diggs(0)
        
 
                    
                     
                    
                 
                    
                
 
 
         浙公网安备 33010602011771号
浙公网安备 33010602011771号