/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

2 votes221 views1 answer
Sql server find columns list in tables
SQL
0 vote210 views1 answer
My sql data file extention
SQL
-1 vote193 views1 answer
Sql getdate date only
SQL
3 votes207 views1 answer
RENAME table pl sql
SQL
1 vote204 views1 answer
Add sequence postgres
SQL
0 vote193 views1 answer
Soql update query
SQL
0 vote194 views1 answer
Oracle get running queries
SQL
18 votes210 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote220 views1 answer
Max length found in mysql
SQL
0 vote228 views2 answers
Generate sql trigger through ef migration
SQL