/SQL/Sql case when exists in another table

Sql case when exists in another table

SELECT A.name, 
       CASE WHEN B.name IS NOT NULL
       THEN 'common'
       ELSE 'not common'
       END

FROM table1 A
LEFT JOIN table2 B
ON A.name = B.name

Source: stackoverflow.com

Similar codes

0 vote103 views1 answer
Nvl2 syntax
SQL
1 vote105 views2 answers
How to drop a unique constraint in sql
SQL
3 votes100 views1 answer
Créer une table sql
SQL
0 vote104 views1 answer
Update top 100 order by sql server
SQL
1 vote100 views2 answers
Select into temp table
SQL
8 votes105 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote109 views1 answer
Postgresql delete limit
SQL
0 vote93 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote95 views1 answer
Reutrn string after character sql
SQL
1 vote117 views1 answer
Sql server kill all connections
SQL