Sql Thopes Ravali Urgent

[runpilagarun]

select col1 , Isnull(col2,'Not Available') from #temp tmp

left join Table1 t1

on tmp.col1 = t1.col2

 

 

This should work

[mtkr]

:5_2_108:

[rikki]

:3D_Smiles_216:

[kiran1012]

Ltt

[mtkr]

Ltt

 

 

ans done... inka ltt Y maayyya....

[ponugupati]

select col1 , 'not available' from (

select col1 from temp#

minus

select col2 from table1

)

[telugodunene]

select col1 , 'not available' from (

select col1 from temp#

minus

select col2 from table1

)

p00ri ni 10gi pregnant ayyaka condom techinattu undi ba ne pani