This discussion is archived
5 Replies Latest reply: Jan 28, 2013 8:20 AM by GRK RSS

Sub Query Design in Rpd

user10675696 Newbie
Currently Being Moderated
Hi,

Please find the below query here and i want to design the rpd for below one

select
m.column1,
N.column1,
N.column1
from
x_abc m,
(select a.column1,a.column2,a.column3,b.column1,b.column2
from
y_abc a,Z_abc b
where a.column1=b.column1
and a.column1=b.column1) N
where
m.column2=N.column1(+)
m.column3=N.column2(+)
m.column4=N.column3(+)

How to achieve it.

Totally i have 3 tables here. 1 is in main query and other 2 are in sub query. Based on the subquery results main query will be executes .


Regards,
MAll

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points