/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

7 votes147 views2 answers
3rd height salary sql
SQL
0 vote146 views1 answer
Sql tablo hangi sp de
SQL
0 vote157 views2 answers
Call to undefined function mysql_query()
SQL
0 vote148 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
5 votes144 views2 answers
Get number of columns sql
SQL
0 vote146 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote172 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote139 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote133 views1 answer
Mysql calculated column
SQL
-2 votes141 views1 answer
Group functions in sql
SQL