/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 vote114 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote130 views1 answer
Replace divide by zero error with 0 in sql
SQL
1 vote126 views1 answer
Myql find duplicates
SQL
2 votes111 views1 answer
Get first 3 letters name in sql
SQL
0 vote117 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote131 views1 answer
Sql server rtrim everything after character
SQL
0 vote124 views1 answer
Replace \n sql
SQL
0 vote130 views1 answer
Test database for sql
SQL
1 vote110 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote113 views1 answer
How to order result of subquery in select
SQL