카테고리 없음

vertca, -4833 subquery in FROM must have an alias

een 2014. 5. 14. 11:44

* 에러가 나는 경우

SELECT 1 FROM

(SELECT 1);


* 조치 : subquery 에 alias 를 붙인다

SELECT 1 FROM

(SELECT 1) AS FOO --   <-- AS ... 

;