This discussion is archived
5 Replies Latest reply: Dec 17, 2012 10:45 AM by Programmer Analyst RSS

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

user1668671 Explorer
Currently Being Moderated
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.

Legend

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