/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

8 votes373 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote342 views1 answer
Kill a pid redshift
SQL
0 vote361 views1 answer
Query to remove duplicate rows from a table
SQL
4 votes440 views3 answers
Mysql get column names from table
SQL
2 votes361 views2 answers
Mysql count rows returned
SQL
2 votes297 views1 answer
Oracle current date without time
SQL
4 votes342 views3 answers
Order by value mysql
SQL
0 vote349 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote337 views2 answers
SQL Server Standard
SQL
11 votes364 views3 answers
How to get last row of table in sql
SQL