/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

-1 vote155 views1 answer
Sql getdate date only
SQL
0 vote170 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote163 views1 answer
Oracle db get table sizes
SQL
0 vote174 views1 answer
How to execute stored output to csv files
SQL
0 vote163 views1 answer
Sql value exists in column
SQL
0 vote167 views1 answer
Recover deleted data from mysql database
SQL
2 votes215 views3 answers
How to replace null values in sql
SQL
0 vote177 views1 answer
How to get specific salary in sql
SQL
0 vote170 views1 answer
Oracle search in date columns
SQL
1 vote171 views1 answer
Return size of tables in mysql
SQL