Querydsl StringSubQuery

QuerydslStringSubQuery.java

public List<Member> getMemberList() {
  QMember m = QMember.member;
  QCommon c = QCommon.common;  
  
  StringSubQuery companyName = subquery().from(c).where(
                                c.cd.eq(m.companyCd)).unique(c.cdNm));
  
  List<Tuple> tList = select().from(m).where(
                        m.companyCd.eq(companyCd)
                    ).list(Projections.tuple(m, companyName));
                    
  List<Member> list = new ArrayList<Member>();
  for (Tuple t : tList) {
    Member member = t.get(0, Member.class);
    member.setCompanyNm(t.get(1, String.class);
    
    list.add(member);
  }
  
  return list;
}