/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 vote157 views1 answer
Selecting all columns from table sql database
SQL
1 vote138 views1 answer
Get table which have specific columns in mysql
SQL
1 vote143 views1 answer
Sql week commencing date
SQL
0 vote130 views2 answers
Soql last year
SQL
2 votes162 views1 answer
Find column in all stored procedures sql server
SQL
1 vote128 views1 answer
T-sql find object by name
SQL
0 vote140 views1 answer
Sql requete number pair
SQL
0 vote150 views2 answers
What is rownum in oracle
SQL
8 votes134 views1 answer
Ltrim sql
SQL
3 votes145 views1 answer
Oracle user privileges
SQL