/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

4 votes245 views3 answers
Postgres drop all tables
SQL
0 vote207 views1 answer
Alter precision
SQL
0 vote229 views1 answer
Openquery join two tables
SQL
1 vote210 views1 answer
Oracle apex run 404
SQL
0 vote206 views1 answer
Show all mongodb
SQL
22 votes205 views3 answers
Join three tables sql
SQL
0 vote229 views1 answer
Postgres row expiration
SQL
7 votes286 views2 answers
Drop index oracle
SQL
0 vote209 views1 answer
Sql file in postgres with pgadmin
SQL
11 votes209 views2 answers
Safe mode off mysql
SQL