/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 vote299 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote363 views1 answer
Delete from table where length sql
SQL
1 vote333 views2 answers
Sql server add time to date
SQL
0 vote343 views1 answer
Kill slow queries mysql
SQL
1 vote342 views1 answer
How to fetch alternate records from two tables
SQL
0 vote333 views1 answer
Postgresql using reserved word as column name
SQL
13 votes308 views3 answers
Sql online code
SQL
0 vote339 views1 answer
Psql generate id in existing database
SQL
1 vote355 views2 answers
Mysql limit offset
SQL
28 votes332 views6 answers
Mysql change user password
SQL