mysql 5.XX버전 부터
SELECT
USER.emp_id AS emp_id, USER.user_name AS user_name, CALL.call_name AS call_name
FROM
tdr_user AS USER LEFT OUTER JOIN tdr_empcall AS CALL
ON USER.call_code=CALL.call_code
해당 쿼리문 에러가 발생합니다.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CALL ON USER.call_code=CALL.call_code' at line 1
mysql 5.XX이전 버전에서는 문제가 없었는대 말이죠
어디가 잘못 된것인가요? 수정좀 부탁드립니다.
|