Home > Back-end >  Take a look at this HQL where is wrong?
Take a look at this HQL where is wrong?

Time:11-20

SELECT
O
The FROM
(
SELECT
Max (c.i nspectVerifyLogId) AS logId,
C.s. hopId
The FROM
Org. Wolfgroup. Inspect. Rubbish. Entity. InspectVerifyLog c
WHERE
C.s. hopId IN: shopIds
AND c.i nspectVerifyId IS NULL
GROUP BY
C.s. hopId
) t1
LEFT the JOIN org. Wolfgroup. Inspect. Rubbish. Entity. InspectVerifyLog o ON t1. LogId=o.i nspectVerifyLogId

Error is
Org. Hibernate. HQL. Internal. Ast. QuerySyntaxException: unexpected token: (near the line 1, column 17 [select o the from (select Max (c.i nspectVerifyLogId) as logId, c.s. hopId from org. Wolfgroup. Inspect. Rubbish. Entity. C.s. hopId InspectVerifyLog c where in: shopIds and c.i nspectVerifyId is null group by c.s. hopId) t1 left join org. Wolfgroup. Inspect. Rubbish. The entity. The InspectVerifyLog o on t1. The logId=o.i nspectVerifyLogId]
  • Related