/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 vote291 views1 answer
Table values functions in SQL
SQL
6 votes286 views2 answers
Mysql version check cmd
SQL
23 votes311 views6 answers
How to create table in sql
SQL
0 vote289 views1 answer
Output table plsql
SQL
2 votes291 views2 answers
Get all columns from table sql
SQL
1 vote281 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
0 vote330 views1 answer
Pl sql disable trigger
SQL
-1 vote295 views1 answer
How to switch user in mysql
SQL
0 vote280 views1 answer
Order by monthly in sql
SQL
1 vote283 views1 answer
Substr sql last character
SQL