select * from (select row_number() over(order by 일련번호) as listnum, * from all_member.dbo.게시판 where 회원코드 = ?) A LEFT JOIN (select 게시판번호, 사용여부 from all_member.dbo.게시판_경매상담 WHERE 사용여부 = 'Y') B ON A.일련번호 = B.게시판번호 where listnum between ((1 - 1 ) * 10) + 1 and (1 * 10) order by listnum desc