Use EXISTS to check if a row is present

Need to find if records from table A can also be found in table B? EXISTS is here to help.

πŸ“Œ Here's the syntax.
πš‚π™΄π™»π™΄π™²πšƒ * π™΅πšπ™Ύπ™Ό πšπšŠπš‹πš•πšŽ_𝚊
πš†π™·π™΄πšπ™΄ π™΄πš‡π™Έπš‚πšƒπš‚ (
πš‚π™΄π™»π™΄π™²πšƒ * π™΅πšπ™Ύπ™Ό πšπšŠπš‹πš•πšŽ_πš‹
πš†π™·π™΄πšπ™΄ πšπšŠπš‹πš•πšŽ_𝚊.πš”πšŽπš’ = πšπšŠπš‹πš•πšŽ_πš‹.πš”πšŽπš’
) πš’πš—πš—πšŽπš›_πššπšžπšŽπš›πš’

Let's walk through this.
1️⃣ the inner query retrieves all the records from table_b that has a common key with table_a.
2️⃣ If the inner query returns any records, the output is simply the the records found in both tables A and B. Otherwise, the query returns no records.

EXISTS is useful when one needs to implement UPDATE/DELETE of rows in one table.

πŸš€ There are multiple ways of implementing the same results. Give it a try! Write the equivalent query using "INNER JOIN" or the "IN" operator in the comment section below.

EXISTS can be used in most RDBMS, including PostgreSQL, MySQL, Oracle, Redshift and Google BigQuery.

πŸ‘‡ Full example below.