/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

3 votes107 views2 answers
Get current year sql
SQL
1 vote95 views3 answers
Remove unique key from a table
SQL
1 vote102 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote113 views1 answer
Mssql dockere
SQL
0 vote98 views1 answer
Datetime postgres typeorm
SQL
1 vote97 views1 answer
How to drop function in sql
SQL
6 votes95 views1 answer
Oracle list primary key
SQL
0 vote104 views1 answer
How to start my sql server on mac
SQL
0 vote101 views1 answer
Optimize sql query
SQL
1 vote103 views2 answers
Find a column in all tables mysql
SQL