이 쿼리가 틀릴게 있는지 여쭤봅니다
본문
쿼리A
SELECT * FROM article LIMIT 10;
쿼리B
SELECT article.* FROM article LEFT JOIN member ON article.user_id = member.user_id LIMIT 10;
쿼리B 실행시 에러 발생
SQL 오류 (1064): 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 'member ON article.user_id = member.user_id LIMIT 10' at line 1uery
아무리 봐도 어디가 틀린지 잘 모르겠습니다.
답변 3
SELECT a.* FROM `article` a LEFT JOIN `member` b ON a.user_id = b.user_id LIMIT 10;
백틱 붙이니 정상 작동 하네요;; 감사합니다
SELECT article.* FROM article LEFT JOIN member ON article.user_id = member.user_id where 1 LIMIT 10;
mysql version 확인해 보세요.
답변을 작성하시기 전에 로그인 해주세요.