Select Top 10 B.news_type, B.news_idx, B.news_title, B.start_dt,
B.end_dt, B.add_file1, B.add_file2, B.write_id, B.write_dt,
B.update_id,
B.update_dt, 1 As CNT, 1 As PAGE
From (Select Top 1 *
From T_NEWS_SCRAP A, T_NEWS B
Where (A.scrap_id = 'seokjoo') And (A.scrap_type =
'1') And (A.scrap_idx = 1) And
(A.scrap_type = B.news_type) And
(A.scrap_idx = B.news_idx)) C Order By C.news_idx Desc
이 쿼리가 어디가 잘못되었는지 한번 봐주시면
감사하겠습니다...^^
이왕이면 자세한 설명도 부탁드립니다...
|