/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 vote137 views3 answers
Sql delete all except
SQL
7 votes124 views2 answers
Show size database mysql
SQL
0 vote146 views1 answer
Sql insert from excel
SQL
1 vote121 views2 answers
How to check username in mysql command line
SQL
1 vote120 views1 answer
Importance of comment in mysql
SQL
11 votes124 views5 answers
Laravel db facade
SQL
2 votes131 views1 answer
Postgresql add entry to table
SQL
18 votes120 views4 answers
Foreign key mySql
SQL
0 vote140 views1 answer
Mysql update set sum
SQL
0 vote120 views1 answer
Mysql change default collation
SQL