/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 vote355 views1 answer
Mysql tables max count
SQL
7 votes383 views2 answers
Mysql check db size
SQL
-1 vote379 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote335 views1 answer
Postgresql get current user name
SQL
1 vote357 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote350 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote346 views1 answer
Hive batch drop table
SQL
0 vote360 views1 answer
How to reset table in sql server
SQL
1 vote356 views1 answer
How to get mysql db size
SQL
0 vote348 views1 answer
Set mysql socket file docker windows
SQL