5 Replies Latest reply: Jan 28, 2013 10:20 AM by GRK RSS

    Sub Query Design in Rpd

    user10675696
      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