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