/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 vote300 views1 answer
Export partttion and import in oracle
SQL
1 vote331 views3 answers
How to update column name in psql
SQL
0 vote323 views1 answer
MySQL INSERT IGNORE Statement
SQL
7 votes301 views1 answer
Safe update mysql
SQL
0 vote304 views1 answer
Mysql preg replace
SQL
1 vote304 views1 answer
Insert column after column mysql
SQL
0 vote287 views1 answer
Oracle list index on table
SQL
-2 votes298 views3 answers
Oracle tablespace usage
SQL
0 vote296 views1 answer
Sqlite closes value
SQL
93 votes426 views4 answers
Create database postgres
SQL