/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 vote260 views1 answer
Postgres 11 add primary key
SQL
12 votes256 views1 answer
How to change the value of a table in sql
SQL
6 votes277 views3 answers
Date_trunc postgres
SQL
9 votes295 views3 answers
Mysql run sql file
SQL
0 vote285 views4 answers
What is unique key in sql
SQL
0 vote224 views0 answer
How to connect to datbase in springboot
SQL
1 vote290 views5 answers
What is in operator in sql
SQL
1 vote274 views1 answer
Error code 1175 mysql fix
SQL
0 vote272 views2 answers
Sql query in dax power bi
SQL
0 vote281 views1 answer
Less mysql display
SQL