Querydsl .in()

QuerydslIn.java

/**
 * select *
 * from single s
 * where s.cd in (select g.cd from group g where g.grp_cd = 'GRP_CD'))
 * /

public List<Single> getList(String grpCd) {
  QSingle s = QSingle.single;
  QGroup g = QGroup.group;
  
  return select().from(s).where(
            s.cd.in(subquery().from(g).where(g.grpCd.eq(grpCd)).list(g.cd))
          ).list(s);
}