/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 vote350 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote348 views1 answer
Sql clear table
SQL
2 votes349 views1 answer
Sql missing records from another table
SQL
8 votes393 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote340 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
4 votes364 views1 answer
Alter session set nls_date_format
SQL
3 votes323 views1 answer
Get all elements sql
SQL
0 vote368 views1 answer
Convert excel into sqllite db using python
SQL
7 votes411 views3 answers
Sql server check if temp table exists
SQL
0 vote362 views1 answer
Sort by last two number sql
SQL