흑흑 이너조인 스칼라 서브쿼리

넘 어렵다 

 

select * from(
  select rownum rnum, c.* from 
  (select * from (select * from community where boardid =1 order by board_num desc) a
  left join (select nickname, picture from STUDY_MEMBER) b on a.nickname = b.nickname) c where rnum between 1 and 4;

이건 꼭 정리해서 적어놔야지 

comBoardInfo comBoardList communityController Community.xml 흐름 정리하기