/SQL/Select true if exists on another table or false sqlserver

Select true if exists on another table or false sqlserver

  select A.name, 
       CASE WHEN B.name IS NOT NULL
       THEN 1
       ELSE 0
       END

    from table1 A
    left join table2 B
    on A.name = B.name

Source: stackoverflow.com

Similar codes

7 votes138 views3 answers
Sql update where id
SQL
0 vote149 views1 answer
Postgress append string in select
SQL
1 vote171 views1 answer
Sql order by timestamp
SQL
0 vote150 views1 answer
Postgresql auto increment not working
SQL
0 vote143 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote134 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote168 views1 answer
Mysql installer no packages found
SQL
3 votes136 views1 answer
Pl sql check if variable is empty
SQL
1 vote178 views1 answer
Oracle select first row order by
SQL
1 vote161 views1 answer
Mysql not supported auth mode
SQL