hql from语句不支持子查询，求解

[tingerwish]

SELECT *
from flight
where id =
(
SELECT FIRST.id,SECOND.id as idd
FROM flight AS FIRST ,flight AS SECOND
WHERE FIRST.begin_airport_id=1 AND SECOND.end_airport_id=2 AND FIRST.end_airport_id=SECOND.begin_airport_id)

我想从子查询里获得两列，然后满足 id = FIRST.id or id=SECOND.id as idd 最后返回 flight
然后改成这样

SELECT *
from flight as one,(
SELECT FIRST.id,SECOND.id as idd
FROM flight AS FIRST ,flight AS SECOND
WHERE FIRST.begin_airport_id=1 AND SECOND.end_airport_id=2 AND FIRST.end_airport_id=SECOND.begin_airport_id)as two
where one.id = two.id or one.id = two.idd

但是 hql 语句 不支持 from 后面跟子查询。

求解。

[爱睡觉的阿狸]

以前试过，好像不能用子查询，所以真的要用子查询，还是写原生sql，用createSQLQuery。

[Error_is_a_gril]

用连接查询试一下