모바일 이패스코리아

SELECT a.TITLE, a.CATEGORY, a.PARAM, a.STORE, a.URL, a.IDX ,a.PARENTS ,b.idx link_idx, a.Step FROM SITE_MENU a left outer join Site_MENU b WITH(NOLOCK) on a.idx =b.parents INNER JOIN (Select PARENTS, MIN(Step) Step FROM SITE_MENU WITH(NOLOCK) WHERE SiteCode=100001 AND Service_Type = 2 AND DISPLAY = 'Y' group by parents) c on b.parents=c.parents and b.Step=c.Step WHERE a.PARENTS = (SELECT PARENTS PARENTS FROM SITE_MENU WITH(NOLOCK) WHERE IDX = ( SELECT parents from SITE_MENU WITH(NOLOCK) WHERE IDX = 5979 )) AND a.Service_Type = 2 AND a.DISPLAY = 'Y' Order by Step

[20개] 더보기

로그인
회원가입
내일배움카드
회원가입
PC버전