HQL嵌套查询(子查询)
说好不能打脸 Java领域优质创作者 博客专家认证 2005-12-16 09:42:01 大哥们帮我看看这句HQL语句,我怎么调他都要报错:
FROM kczx.dataobject.T05 AS doT05 WHERE doT05.T0507 <> '' AND doT05.T0501 LIKE '%我%' AND doT05.T0502 IN (SELECT dot02.T0200 FROM kczx.dataobject.T02 dot02 WHERE dot02.T0201 = 'yin-wen-jie') AND doT05.T0506 IN (SELECT dot12.T1200 FROM kczx.dataobject.T12 dot12 WHERE dot12.T1200 = 1) ORDER BY doT05.T0504 DESC,doT05.T0500 DESC