alias error 뜨는 경우 join 건 부분 확인할 것 join 건 쿼리의 select 절 alias 추가해주기 예시 코드 @Query(value ="select * from Order o " + "left join (select orderSeq as orderSeq, name as name from OrderProduct " + ") op on op.orderSeq = o.orderSeq") List getOrderList(OrderCondition condition);