/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

28 votes196 views4 answers
Mysql delete database
SQL
0 vote194 views1 answer
T sql cursor tr
SQL
0 vote234 views1 answer
Mysql config address
SQL
7 votes217 views3 answers
Convert ansi sql
SQL
-1 vote212 views1 answer
Mysql change database charset and collation
SQL
0 vote183 views1 answer
Mysql show category once count how many products
SQL
0 vote210 views1 answer
Sql_inner_join
SQL
4 votes210 views3 answers
Rename table column postgresql
SQL
0 vote218 views1 answer
Java spring boot connect to sql server
SQL
37 votes194 views3 answers
Postgresql insert column
SQL