/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

1 vote250 views1 answer
Sql query row number group by
SQL
1 vote253 views1 answer
Postgresql pass array in function
SQL
0 vote207 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote229 views2 answers
Clauses in mysql
SQL
0 vote199 views1 answer
Oracle synonym procedure dblink
SQL
0 vote189 views2 answers
Sql having multiple conditions
SQL
0 vote198 views1 answer
With_for_update sqlalchemy
SQL
6 votes194 views2 answers
Stored procedure to delete data from table in mysql
SQL
2 votes177 views1 answer
Oracle create directory
SQL
0 vote213 views1 answer
Sql select lowest value row
SQL