我有一个列名称的sql表A
name, id1, id2, val1
和一个带有列名称的表B
id1, id2, key1, key2
这是我的sql查询
SELECT
v1.id1,
v1.id2
FROM (
SELECT
A.id1,
A.id2,
min(val1) AS x
FROM A
JOIN B ON A.id1 = B.id1 AND A.id2 = B.id2
GROUP BY A.id1, A.id2
) AS v1
WHERE v1.x > 10
使用DetachedCriteria我能够形成子查询
DetachedCriteria subCriteria = DetachedCriteria.forClass(A_model.class);
subCriteria.createAlias("b", "b_model");
subCriteria.setProjection(Projections.projectionList()
.add(Projections.groupProperty("id1"))
.add(Projections.groupProperty("id2"))
.add(Projections.min("val1"),"x");
但是我在创建外部查询时面临着很大的困难.
任何建议如何创建上述SQL的标准?
感谢预期.