Help! with Parameter Query for complex SQL

[robottv]

Is there a way to use Parameter Query which contains SQL statement that
contains multiple select statement within the SQl statement?

For example,

<Case 1>
select a.name, b.dept_name, c.salary
from employee a,
dept b,
hr c
where a.emp_id = b.emp_id
and b.band = c.band
and c.salary > 39999

=> THis will work with Parameter Query since it only contains one select
statement

<Caase 2>
select a.name, b.detp_name, c.salary
from employee a,
dept b,
( select *
from hr
where salary > 39999
) c
where a.emp_id = b.emp_id
and b.band = c.band

=> THis will not work with Parameter Query since it contains sub select
statement

Please let me know how I can use Parameter Query for case 2.

Thanks