SQLD · 제58회 · 24번

Question

다음 조인(JOIN) 문법 중 실행 시 에러가 발생하는 것은?

Accepted Answer

SELECT * FROM T1 NATURAL JOIN T2 ON T1.ID = T2.ID;

Answer

SELECT * FROM T1 JOIN T2 USING (ID);

Answer

SELECT * FROM T1 JOIN T2 ON T1.ID = T2.ID;

Answer

SELECT * FROM T1, T2 WHERE T1.ID = T2.ID;