/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 vote300 views1 answer
Compress sql file database ubuntu
SQL
3 votes237 views1 answer
Mysql UPDate with enner join
SQL
10 votes271 views4 answers
Primary key in sql
SQL
1 vote267 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes265 views1 answer
Locate sql server
SQL
-1 vote258 views2 answers
Postgresql get last 10 records
SQL
0 vote267 views1 answer
Mysql query to select the highest value
SQL
1 vote247 views1 answer
User privileges postgresql information_schema
SQL
0 vote251 views1 answer
Linked server delete openquery
SQL
0 vote266 views1 answer
Logtash mysql cofiguration file
SQL