/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

0 vote235 views1 answer
Mysql c commands
SQL
0 vote221 views1 answer
Ora 00001 error catch plsql
SQL
0 vote225 views1 answer
Set column width in sqlplus
SQL
0 vote236 views1 answer
Sql datediff db2
SQL
0 vote188 views1 answer
Sql new line output
SQL
2 votes219 views1 answer
Oracle sql drop table purge
SQL
1 vote232 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
1 vote224 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
2 votes228 views1 answer
Wait delay in sql server
SQL
0 vote227 views1 answer
Sql string contains case sensitive
SQL