Sql Thopes Ravali Urgent

[puli_keka]

i have a temp table with col1  ,  inserted some records..

 

I want to display whther the value in temp table available or not in other actual table

 

best way enti

 

#temp   (col1 nvarchar(10))

 

i have   abc , cda,  lmn

 

Table1  ( col2 nvarchar(10), col 3 int, col4 int)

abc,0,0

 

select col1  from #temp tmp

left join Table1 t1

on t1.col2 = tmp.col1

 

final result 

 

abc    available

cda    not available 

lmn    not available

 

ala for all the values in temp table

 

 

Edit:  done..  used case when exists from table1

[puli_keka]

CITI#H@  CITI#H@

[rikki]

question not clear

[puli_keka]

question not clear

 

update chesa bhayya.. basic ga temp tabale lo unna value actual table lo lekapothe adhi display cheyali

[telugodunene]

update chesa bhayya.. basic ga temp tabale lo unna value actual table lo lekapothe adhi display cheyali

ekkada display cheyali 

[puli_keka]

ekkada display cheyali 

 

aa select query lo ravali   like columnvalue , 'availble/not availabl' in actual table' ani .. 

[puli_keka]

modified the question  CITI#H@

[puli_keka]

CITI#H@

[spidereddy]

ocheshna..

[spidereddy]

cheshnav kada join..inkem kavale?

[spidereddy]

case statement petkon..null aite not avaible pet..

[spidereddy]

sorry gif marchpoina..

[Hyderabad_Nawab]

PM Loveindia..

[raj_hyd]

Calling thopes

[puli_keka]

case when exists then else end  vaadithe aipoyindi