/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

9 votes104 views4 answers
Add primary key to existing table sql
SQL
0 vote119 views1 answer
Renommer base sql
SQL
2 votes127 views1 answer
Oracle trace file
SQL
5 votes65 views1 answer
Postgres upsert
SQL
0 vote116 views1 answer
Setval in postgres
SQL
7 votes108 views1 answer
Query delete duplicates
SQL
0 vote104 views1 answer
Add column to table with default value plsql
SQL
0 vote104 views1 answer
Database xml sql
SQL
3 votes140 views1 answer
How to get yesterday date in sql
SQL
-1 vote107 views1 answer
How to check table exists or not in postgresql
SQL