mysql - HQL 左连接不起作用

Question

尝试为以下 SQL 查询编写等效的 hql 查询:

(SQL):

SELECT * FROM Game g LEFT JOIN RollbackGame rb ON g.id = rb.id WHERE rb.gameId IS NULL

(HQL):

SELECT g FROM Game g LEFT JOIN RollbackGame rb WITH g.id = rb.gameId WHERE rb.gameId IS NULL

HQL 对我不起作用，有什么想法吗？ (用hql可以实现吗？)

编辑:我收到这种错误:

Path expected for join! [SELECT g FROM com.xxx.model.game.Game g LEFT JOIN RollbackGame AS rb WITH g.id = rb.gameId WHERE rb.gameId IS NULL

谢谢

Answer 1

您的HQL应如下所示:

SELECT g FROM Game g LEFT JOIN RollbackGame AS rb WITH g.id = rb.gameId WHERE rb.gameId IS NULL

您忘记了别名前的 AS 关键字。