/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

2 votes221 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote169 views1 answer
What is the essence of SQL?
SQL
0 vote269 views1 answer
Shortcut run sql pgadmin
SQL
1 vote178 views3 answers
Sql select only time from datetime
SQL
0 vote188 views1 answer
C# get sql min date
SQL
2 votes306 views2 answers
MySql FULL OUTER JOIN
SQL
18 votes177 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote130 views1 answer
Postgres reset auto increment
SQL
0 vote169 views1 answer
Mysql percentage of total
SQL
0 vote253 views1 answer
Offset in postgresql example
SQL