sql 转hql 左连接 外键配置 fetch select

Question

SELECT
DISTINCT(p.CClassId)
FROM
poor_application p
LEFT JOIN basic_class bc ON p.CClassId = bc.CID
LEFT JOIN basic_academyinfo bac ON bc.AcademyCode = bac.AAcademyCode
WHERE
bac.AAcademyCode = "222"
AND p.PAACheck="1"
AND p.PATCheck="1"
AND p.PAUCheck="1"
AND p.PID="1"

Answer 1

@ManyToOne(fetch=FetchType.LAZY)
@JoinColumn(name="bid")
试试注解的方式