/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 vote349 views1 answer
DATEDIFF minute postgres
SQL
4 votes397 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote350 views1 answer
Sqlite3 update select
SQL
0 vote331 views1 answer
Mysql order by where condition sub query
SQL
1 vote373 views1 answer
Login to database mysql terminal
SQL
0 vote351 views1 answer
Mysql url data type
SQL
0 vote389 views1 answer
Delete from IN subquery
SQL
0 vote341 views3 answers
Average salary in sql
SQL
0 vote336 views1 answer
How to find columns with null values in sql
SQL
1 vote332 views2 answers
Check if word is in column sql
SQL