Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Symbol_of_king Kurra Bewarse Username: Symbol_of_king Post Number: 2234 Registered: 12-2005 Posted From: 72.219.244.175 Rating: N/A Votes: 0 Posted on Thursday, August 18, 2016 - 10:43 am:    i think your problem is outer join on two tables in same query... below query may work but may not be effective interms of performance select 1.B,23.E (select 2c.A,3.E from (select A,D from 2a where 2a.C='x' and 2a.creation_dt=(select max(creation_dt) from table2b where 2a.A=2b.A and 2a.D=2b.D)) 2c, 3 where 2c.D=3.D) 23, 1 where 1.A=23.A(+)