/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

21 votes194 views6 answers
Update sql
SQL
0 vote146 views1 answer
Oracle dynamic select into
SQL
0 vote186 views1 answer
Mysql extract day from date leading zero
SQL
4 votes142 views2 answers
Mysql select where starts with
SQL
3 votes152 views1 answer
Locate sql server
SQL
0 vote166 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote173 views1 answer
SQL Where-Klausel
SQL
0 vote166 views1 answer
TSQL convert csv to table
SQL
0 vote163 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote139 views1 answer
Oracle search columns in schema
SQL