SQLD 기출문제 예상문제 179번

다음 문제를 풀어보세요.

다음 중 ANSI 표준 조인 구문을 사용하여 작성된 SQL문이 아닌 것을 고르시오.

다음은 고객(CUSTOMER) 테이블과 주문(ORDER) 테이블의 구조입니다.
CREATE TABLE CUSTOMER (
    CUSTOMER_ID VARCHAR2(10) PRIMARY KEY,
    CUSTOMER_NAME VARCHAR2(50),
    CITY VARCHAR2(50)
);

CREATE TABLE ORDER (
    ORDER_ID VARCHAR2(10) PRIMARY KEY,
    CUSTOMER_ID VARCHAR2(10) REFERENCES CUSTOMER(CUSTOMER_ID),
    ORDER_DATE DATE,
    TOTAL_AMOUNT NUMBER
);

SELECT C.CUSTOMER_NAME, O.ORDER_ID FROM CUSTOMER C INNER JOIN ORDER O ON C.CUSTOMER_ID = O.CUSTOMER_ID;

SELECT C.CUSTOMER_NAME, O.ORDER_ID FROM CUSTOMER C LEFT OUTER JOIN ORDER O ON C.CUSTOMER_ID = O.CUSTOMER_ID;

SELECT C.CUSTOMER_NAME, O.ORDER_ID FROM CUSTOMER C, ORDER O WHERE C.CUSTOMER_ID = O.CUSTOMER_ID;

SELECT C.CUSTOMER_NAME, O.ORDER_ID FROM CUSTOMER C RIGHT OUTER JOIN ORDER O ON C.CUSTOMER_ID = O.CUSTOMER_ID;