/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 vote245 views1 answer
Java input type sql date
SQL
6 votes298 views3 answers
Psql show columns of table
SQL
-1 vote251 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
1 vote268 views1 answer
Mysql size int
SQL
1 vote259 views1 answer
Alter constraint postgres
SQL
10 votes240 views4 answers
Primary key sql
SQL
0 vote246 views1 answer
Oracle job schedules
SQL
1 vote276 views1 answer
Postgresql where datetrunc month and year equal
SQL
2 votes279 views1 answer
Ifnull postgres
SQL
0 vote200 views1 answer
Oracle sql replace string in clob
SQL