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

Author Message   Onlymovies Censor Bewarse Username: Onlymovies Post Number: 36159 Registered: 01-2009 Posted From: 137.200.32.54 Rating: N/A Votes: 0 Posted on Thursday, August 18, 2016 - 7:41 am:    Table 1 lo A, B ane 2 columns vunnayi. Table 2 lo A, C, D ane 3 columns vunnayi. Table 3 lo D, E ane 2 columns vunnayi. For a give A, I need to get B, E. I should get E only when C ='x', if C is not 'x' or there is nor record for A in table 2, E should be blank. ela rayaali query? select B, E from 1,2,3 where A = 'Given vlaue' and C = 'x' and 1.A = 2.A(+) and 2.D = 3.D ani rasaanu, when C != 'x' I am not getting no records back, but still I need (B, null) back. konchem light veyyandi.. Devarakota.. paiga marumoola maamidi thota... adige dikku kooda ledu...