/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 vote68 views1 answer
Oracle function select into
SQL
1 vote113 views1 answer
Sql restore backup query
SQL
0 vote127 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
3 votes110 views1 answer
Oracle revoke
SQL
0 vote121 views1 answer
Create a view in sqlite
SQL
5 votes120 views1 answer
Oracle asynchronous update
SQL
1 vote121 views2 answers
Datetrunc hour snowflake
SQL
0 vote101 views1 answer
Sort by last two number sql
SQL
-1 vote139 views1 answer
Ms sql select datetime as date
SQL
0 vote117 views1 answer
Mysql workbench indent formatting
SQL