/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

4 votes334 views2 answers
Select first and last row mysql
SQL
-1 vote359 views1 answer
Create view in mysql workbench
SQL
4 votes281 views1 answer
And or sql order of operations
SQL
-3 votes422 views8 answers
Sql to c# linq converter online
SQL
-1 vote334 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
-1 vote311 views2 answers
Full join sql
SQL
0 vote359 views1 answer
Mysql last 6 months
SQL
1 vote312 views1 answer
How to select random rows from table
SQL
3 votes334 views2 answers
Sql select data from last week
SQL
1 vote339 views4 answers
Aggregate function in sql
SQL