●SQL: SELECT * FROM ( SELECT NEWS.NEWS_CD as NEWS_CD, NEWS.HEADER as HEADER, NEWS.NEWS_YMD as NEWS_YMD, IMG_FILE as IMG_FILE FROM NEWS_ARTIST, NEWS WHERE (NEWS_ARTIST.NEWS_CD = NEWS.NEWS_CD) AND (NEWS.NEWS_YMD > '2007/05/01') AND NEWS_ARTIST.ARTIST_CD in ( 'VIBE-ARTIST030004686', 'VIBE-ARTIST020004339', 'VIBE-ARTIST000000295', 'VIBE-ARTIST020000459', 'VIBE-ARTIST030006650', 'VIBE-ARTIST000000302', 'VIBE-ARTIST021005473', 'VIBE-ARTIST030005588', 'VIBE-ARTIST030004287', 'VIBE-ARTIST030005930', 'VIBE-ARTIST020004343', 'VIBE-ARTIST030004576', 'VIBE-ARTIST020004251', 'VIBE-ARTIST030006729', 'VIBE-ARTIST020001726', 'VIBE-ARTIST030002583', 'VIBE-ARTIST010000682', 'VIBE-ARTIST030002529', 'VIBE-ARTIST000000425', 'VIBE-ARTIST030004594', 'VIBE-ARTIST010000733', 'VIBE-ARTIST020000755', 'VIBE-ARTIST000000392', 'VIBE-ARTIST030000943', 'VIBE-ARTIST030006109', 'VIBE-ARTIST030006727', 'VIBE-ARTIST030004453', 'VIBE-ARTIST030006582', 'VIBE-ARTIST020002016', 'VIBE-ARTIST030006219', 'VIBE-ARTIST000000063', 'VIBE-ARTIST030002251', 'VIBE-ARTIST030005195', 'VIBE-ARTIST020002110', 'VIBE-ARTIST030000081', 'VIBE-ARTIST020002672', 'VIBE-ARTIST010000721', 'VIBE-ARTIST000000081', 'VIBE-ARTIST030006640', 'VIBE-ARTIST000000455', 'VIBE-ARTIST030004376', 'VIBE-ARTIST030006098', 'VIBE-ARTIST000000227', 'VIBE-ARTIST000000462', 'VIBE-ARTIST020004344', 'VIBE-ARTIST030006328', 'VIBE-ARTIST020004538', 'VIBE-ARTIST030005487', 'VIBE-ARTIST020000933', 'VIBE-ARTIST030004659', 'VIBE-ARTIST030006618', 'VIBE-ARTIST000000099', 'VIBE-ARTIST030002361', 'VIBE-ARTIST030006719', 'VIBE-ARTIST030004647', 'VIBE-ARTIST030000657', 'VIBE-ARTIST020004612', 'VIBE-ARTIST030006720', 'VIBE-ARTIST030005644', 'VIBE-ARTIST030005804', 'VIBE-ARTIST030006512', 'VIBE-ARTIST010001083', 'VIBE-ARTIST000000510', 'VIBE-ARTIST030006667', 'VIBE-ARTIST030004957', 'VIBE-ARTIST030003103', 'VIBE-ARTIST030001419', 'VIBE-ARTIST020000704', 'VIBE-ARTIST020001305', 'VIBE-ARTIST030005919', 'VIBE-ARTIST030002375', 'VIBE-ARTIST020003182', 'VIBE-ARTIST030006470', 'VIBE-ARTIST030005763', 'VIBE-ARTIST030005664', 'VIBE-ARTIST020005085', 'VIBE-ARTIST030006494', 'VIBE-ARTIST020004167', 'VIBE-ARTIST030002505', 'VIBE-ARTIST020004482', 'VIBE-ARTIST030004538', 'VIBE-ARTIST030002112', 'VIBE-ARTIST030004856', 'VIBE-ARTIST030001257', 'VIBE-ARTIST020004300', 'VIBE-ARTIST020000856', 'VIBE-ARTIST020000924', 'VIBE-ARTIST030004341', 'VIBE-ARTIST030000537', 'VIBE-ARTIST030005769', 'VIBE-ARTIST000000124', 'VIBE-ARTIST030006093', 'VIBE-ARTIST020004946', 'VIBE-ARTIST030004297', 'VIBE-ARTIST020001044', 'VIBE-ARTIST000000550', 'VIBE-ARTIST030006054', 'VIBE-ARTIST020000949' ) ORDER BY NEWS_YMD DESC ) WHERE ROWNUM <= 50の実行に失敗しました。
ERROR: sub-SELECT in FROM must have an alias For example, FROM (SELECT ...) [AS] foo