/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 vote185 views1 answer
SQL query to verify the size of the table
SQL
0 vote141 views1 answer
Sqlite3 not commit
SQL
-1 vote156 views1 answer
Create view in mysql workbench
SQL
0 vote126 views1 answer
Doesn't have default value mysql
SQL
0 vote125 views1 answer
Mysql convert charset
SQL
0 vote138 views1 answer
Mysqldump don't drop table
SQL
0 vote178 views1 answer
Selecting from a view SQL
SQL
1 vote132 views2 answers
Oracle replace
SQL
2 votes137 views1 answer
Metasploit start postgresql
SQL
1 vote132 views3 answers
Mysql disable foreign keys check
SQL