ROCK IN JAPAN FES.2007出演アーティストの最新ニュースをチェック!
●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/06/01') AND NEWS_ARTIST.ARTIST_CD in
(
'VIBE-ARTIST020004847',
'VIBE-ARTIST030005082',
'VIBE-ARTIST021005108',
'VIBE-ARTIST030006168',
'VIBE-ARTIST000000112',
'VIBE-ARTIST020000856',
'VIBE-ARTIST030005568',
'VIBE-ARTIST030006356',
'VIBE-ARTIST000000045',
'VIBE-ARTIST030004787',
'VIBE-ARTIST030004917',
'VIBE-ARTIST030006574',
'VIBE-ARTIST030002097',
'VIBE-ARTIST020000148',
'VIBE-ARTIST030006101',
'VIBE-ARTIST020004145',
'VIBE-ARTIST020003974',
'VIBE-ARTIST000000027',
'VIBE-ARTIST030004326',
'VIBE-ARTIST030005197',
'VIBE-ARTIST030005829',
'VIBE-ARTIST030002642',
'VIBE-ARTIST000000021',
'VIBE-ARTIST030005417',
'VIBE-ARTIST030005612',
'VIBE-ARTIST020004387',
'VIBE-ARTIST030001298',
'VIBE-ARTIST030004687',
'VIBE-ARTIST000000091',
'VIBE-ARTIST030005454',
'VIBE-ARTIST030005151',
'VIBE-ARTIST030001553',
'VIBE-ARTIST030001664',
'VIBE-ARTIST030002702',
'VIBE-ARTIST000000139',
'VIBE-ARTIST000000132',
'VIBE-ARTIST000000037',
'VIBE-ARTIST030001421',
'VIBE-ARTIST030002771',
'VIBE-ARTIST020000790',
'VIBE-ARTIST030006121',
'VIBE-ARTIST030000714',
'VIBE-ARTIST020000937',
'VIBE-ARTIST030006249',
'VIBE-ARTIST030005814',
'VIBE-ARTIST030006300',
'VIBE-ARTIST030000836',
'VIBE-ARTIST030005985',
'VIBE-ARTIST020003201',
'VIBE-ARTIST030001379',
'VIBE-ARTIST030005788',
'VIBE-ARTIST030005724',
'VIBE-ARTIST021005104',
'VIBE-ARTIST030005843',
'VIBE-ARTIST030003110',
'VIBE-ARTIST030004310',
'VIBE-ARTIST020000766',
'VIBE-ARTIST030006698',
'VIBE-ARTIST020000691',
'VIBE-ARTIST020004435',
'VIBE-ARTIST030004688',
'VIBE-ARTIST030005749',
'VIBE-ARTIST030005782',
'VIBE-ARTIST030005897',
'VIBE-ARTIST030006088',
'VIBE-ARTIST030000404',
'VIBE-ARTIST030004707',
'VIBE-ARTIST030004429',
'VIBE-ARTIST000000025',
'VIBE-ARTIST030003094',
'VIBE-ARTIST030000190',
'VIBE-ARTIST030005698',
'VIBE-ARTIST020000486',
'VIBE-ARTIST020000437',
'VIBE-ARTIST000000093',
'VIBE-ARTIST030004297',
'VIBE-ARTIST030000431',
'VIBE-ARTIST030002112',
'VIBE-ARTIST030005646',
'VIBE-ARTIST030002138',
'VIBE-ARTIST030006647',
'VIBE-ARTIST030004845',
'VIBE-ARTIST020001313',
'VIBE-ARTIST030005271',
'VIBE-ARTIST020002642',
'VIBE-ARTIST030001709',
'VIBE-ARTIST020003207',
'VIBE-ARTIST020003546'
)
ORDER BY NEWS_YMD DESC
) WHERE ROWNUM <= 50の実行に失敗しました。
ERROR: sub-SELECT in FROM must have an alias
For example, FROM (SELECT ...) [AS] foo
|