Sql Doubt

[Desamudhuru]

COALESCE function mida doubt evariki iyina telusa ??


code is here

COALESCE (TL.MTR,TL.ISR,TL.WTR,TL.GOV,TL.INT,TL.NAT) AS SLS1__C,


SLS2__C = (CASE WHEN SLS1__C = TL.MTR
THEN
COALESCE (TL.ISR,TL.WTR,TL.GOV,TL.INT,TL.NAT)
WHEN SLS1__C = TL.ISR
THEN
COALESCE (TL.WTR,TL.GOV,TL.INT,TL.NAT)
WHEN SLS1__C = TL.WTR
THEN
COALESCE (TL.GOV,TL.INT,TL.NAT)
WHEN SLS1__C = TL.GOV
THEN
COALESCE (TL.INT,TL.NAT)
WHEN SLS1__C =TL.NAT
THEN
''

END ),
SLS3__C = (CASE WHEN SLS2__C = TL.ISR
THEN
COALESCE (TL.WTR,TL.GOV,TL.INT,TL.NAT,'')
WHEN SLS2__C = TL.WTR
THEN
COALESCE (TL.GOV,TL.INT,TL.NAT,'')
WHEN SLS2__C = TL.GOV
THEN
COALESCE (TL.INT,TL.NAT,'')
WHEN SLS2__C = TL.INT
THEN COALESCE(TL.NAT,'')
WHEN SLS2__C = TL.NAT
THEN ''
END ),



SLS1__C SELECT IYAKA SLS2__C LO DANI NEXT DI RAVALI
SLS2__C SELECT IYAKA SLS3__C LO DANI NEXT DI RAVALI

[Desamudhuru]

ltt

[Mrlavangam]

deentlo error em vasthundi??

[papacha]

what are you getting instead of what you want?

[vizagpower]

[img]http://www.desigifs.com/sites/default/files/venki-o.gif?1291144470[/img]

[Desamudhuru]

[quote name='Mrlavangam' timestamp='1357666473' post='1303071854']
deentlo error em vasthundi??
[/quote]
[quote name='papacha' timestamp='1357666628' post='1303071880']
what are you getting instead of what you want?
[/quote]


thanks for ur reply though. Error with the table not with the query. Nenu rasindi correct ee.