/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

1 vote207 views2 answers
Sql multiline comment
SQL
0 vote212 views1 answer
Like date sql server not working
SQL
6 votes214 views3 answers
Create database mysql utf8
SQL
1 vote207 views1 answer
Alter constraint in sql
SQL
0 vote209 views1 answer
Sql getdate minus 1 day without time
SQL
2 votes197 views2 answers
Mysql get time from datetime
SQL
16 votes249 views3 answers
Order by sql query
SQL
1 vote254 views2 answers
List tables sqlalchemy
SQL
0 vote235 views1 answer
Time data type in mysql
SQL
15 votes180 views7 answers
MYSQL
SQL