how to put subquery in from clause
698326Jul 17 2009 — edited Jul 17 2009Hi All,
I want to put a subquery in my from clause . I want to show the details of an account when the status is active but i want to show the date when it has opened.
Below is my report query .
select t.acct_id,x.acct_status_Dt
from cust_acct t , (select t1.acct_id, t1.acct_status_Dt from cust_acct t1 where t1.acct_status_code='OPEN') x
where t.acct_id= x.acct_td
and t.acct_status_code='ACTIVE'
Anybody knows how to impliment this type of query in OBIEE without RPD changes.
Please help..