SQL에서 궁금한 것(해결)

1.

SELECT emp.id AS '사원번호',

emp.name AS '이름',

emp.regDate AS '입사날짜',

dept.name AS '부서명'

FROM emp

INNER JOIN dept

ON emp.deptId=dept.id

ORDER BY dept.id;

 

2.

SELECT emp.id AS '사원번호',

emp.name AS '이름',

emp.regDate AS '입사날짜',

dept.name AS '부서명'

FROM emp, dept

WHERE emp.deptId=dept.id

ORDER BY dept.id;

 

1과 2는 동일한 결과를 보여주는데, 둘 중 무엇을 쓰든 상관이 없는 것일까?

=> 기능은 동일하나 관례상 !