/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

1 vote346 views2 answers
Mysql: command not found
SQL
5 votes343 views3 answers
Oracle list columns in schema
SQL
3 votes325 views1 answer
Index using in query plsql
SQL
10 votes395 views2 answers
Doublon sql
SQL
5 votes386 views4 answers
Mysql update column with value from another table
SQL
1 vote360 views3 answers
Sql server get week dates from week number
SQL
0 vote346 views1 answer
QUERY JPQL
SQL
0 vote358 views1 answer
What does leave do in mysql
SQL
3 votes364 views2 answers
MySQL query to get column names
SQL
2 votes363 views2 answers
Mysql search for column name in all tables
SQL