SQL urgent help bhayya

[HyderabadPoradu]

Bhayya,

kocham urgent help needed..

Table a and table b join chesi table a  nunchi oka value thechukovali.. if the value is null then it should join table c and get the value, if the value is null then leave it as as null.

 

[crazymata]

1 minute ago, HyderabadPoradu said:

Bhayya,

kocham urgent help needed..

Table a and table b join chesi table a  nunchi oka value thechukovali.. if the value is null then it should join table c and get the value, if the value is null then leave it as as null.

 

coalesce function vadaledha??

[JollyBoy]

select isnull(a.oka_value,c.oka_value) from tab1 a

inner join tab2 b

on a.join_value = b.join_value

inner join tab3 c

on b.join_value = c.join_value

[JollyBoy]

enni dinal nundi job chestunav kaka

[HyderabadPoradu]

54 minutes ago, JollyBoy said:

enni dinal nundi job chestunav kaka

kaka nenu mottam logic veyyaledhu..those two logics are dependent on many other dependencies..I did not frame it in correct way.. thanks for the inputs though

[HyderabadPoradu]

1 hour ago, crazymata said:

coalesce function vadaledha??

vaadina bhayya,,still need to tweak a lot..the crazy thing is tht there r many dependent logics...i'll reframe it again.. thanks!

[crazymata]

1 hour ago, HyderabadPoradu said:

vaadina bhayya,,still need to tweak a lot..the crazy thing is tht there r many dependent logics...i'll reframe it again.. thanks!

ok