작성
·
420
1
// return em.createQuery(
// "select distinct o from Order o " +
// " join fetch o.orderBooks ob" +
// " join fetch ob.book" +
// " where o.member.id = :memberId", Order.class)
// .setParameter("memberId", memberId)
// .getResultList();
return em.createQuery(
"select o from Order o " +
" join fetch o.orderBooks ob" +
" join fetch ob.book" +
" where o.member.id = :memberId" +
" group by o", Order.class)
.setParameter("memberId", memberId)
.getResultList();