Oracle 5 테이블 3개연결! Ansi표준 employees와 jobs, departments를 연결 Step1.테이블 2개연결 select e.*,j.* from employees e inner join jobs j on e.job_id=j.job_id Step2.테이블 3개 연결 select e.last_name,e.first_name,j.job_title,d.department_name from employees e inner join jobs j on e.job_id=j.job_id inner join departments d on e.department_id=d.department_id Oracle에서 3테이블 연결 select e.first_name,e.last_name,j.job_title,d.depar.. 더보기 이전 1 ··· 40 41 42 43 44 45 46 ··· 151 다음