5 Replies Latest reply: Dec 17, 2012 12:45 PM by Programmer Analyst RSS

    All the data in driving table should be displayed - obiee 10g

    user1668671
      Hi All,

      Table T1
      Col1 col2
      A AA1
      B BB1
      C CC1
      D DD1
      ------------------------------------
      Table T2
      col1 Col2 col3
      A 200 01-DEC-2012
      B 300 03-DEC-2012
      D 250 05-DEC-2012
      ---------
      Result to be:
      A 200 01-DEC-2012
      B 300 03-DEC-2012
      C
      D 250 05-DEC-2012


      When we pass date parameter from 01-DEC to 05-DEC
      Then the result we are getting is

      A 200 01-DEC-2012
      B 300 03-DEC-2012
      D 250 05-DEC-2012

      We need to get all the records from Table T1 irrespective of whether the records present in Table T2 or not.

      we tried joins but didnt worked..

      Thanks.