I have the following two select queries, i want to use teh second second in the first query join is it possible:
select plan_name from health_plan where health_plan.health_plan_id = E_Plan_R.health_plan_id and
health_plan.active_ind=1
i want to use this query to get health_plan_id which is used in teh above query after equalto sign, is it possible to directly use it there in the above query to make as one single instead of two.
select health_plan_id from encntr_plan_reltn where enc.encid= encntr_plan_reltn.encid and priority_seq=1 and active_ind=1
and beg_eff_dt > = sysdate();
I am planning to use the above query's as inquery/subquery within a big sql query block where all joins etc already defined and working just want to add the above one.
Thank you very much for the help.
Is it possible to use select within join condition
Posted - 11/27/2012 : 16:53:54
