如何在休眠状态下编写子查询 [英] How to write subquery in hibernate

问题描述

我有SQL查询，我不知道如何在休眠状态下写

i have SQL query , i don't know how to write in hibernate

select lp.lnprdtname,la.lid,la.step 
from mfic.lnapp as la 
left join mfic.lnprdt as lp on lp.lnprdtid in 
    (select lnprdtid from mfic.lnapp where lid in 
        (select lid from mfic.lnbrwr where brwrid in 
            (select brwrid from mfic.brwr where uid=1)))
where la.lid in 
    (select lid from mfic.lnbrwr where brwrid in 
        (select brwrid from mfic.brwr where uid=1));

推荐答案

如此处所述: 第14章.HQL:休眠查询语言-14.13.子查询

from DomesticCat as cat
where cat.name not in (
    select name.nickName from Name as name
)

请注意，HQL子查询只能在select或where子句中出现.

Note that HQL subqueries can occur only in the select or where clauses.

无论如何，我不确定在单个语句中包含这么多子查询是一个好主意...

Anyway, I'm not sure it's a good idea to concat so many subqueries in a single statement...

这篇关于如何在休眠状态下编写子查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！