hql是from SysDictItem t where t.vcMId = (select m.vcId from SysDictM m where m.vcDelFlag=0 and m.vcName ='国家管理' ) and t.vcDelFlag = 0 order by t.nseq asc,t.vcItemName,t.vcId,输出的sql是Hibernate: select sysdictite0_.VC_ID as VC1_101_, sysdictite0_.VC_M$ID as VC2_101_, sysdictite0_.VC_ITEM$NUMBER as VC3_101_, sysdictite0_.VC_ITEM$NAME as VC4_101_, sysdictite0_.VC_ITEM$NOTE as VC5_101_, sysdictite0_.VC_ORG$ID as VC6_101_, sysdictite0_.VC_ORG$TYPE$FLAG as VC7_101_, sysdictite0_.N_SEQ as N8_101_, sysdictite0_.DT_CREATE as DT9_101_, sysdictite0_.VC_DEL$FLAG as VC10_101_ from SYS_T_DICT$ITEM sysdictite0_ where sysdictite0_.VC_M$ID=(select sysdictm1_.VC_ID from SYS_T_DICT$M sysdictm1_ where sysdictm1_.VC_DEL$FLAG=0 and sysdictm1_.VC_NAME='国家管理') and sysdictite0_.VC_DEL$FLAG=0 order by sysdictite0_.N_SEQ asc, sysdictite0_.VC_ITEM$NAME, sysdictite0_.VC_ID
，我把sql语句放到mysql客户端执行是有数据的，截图如下：