There is a requirement to combine data from two different tables horizontally using a shared column as the key column. Output should have only those rows from "table_1" for which the value in the key column is present in both tables and all the rows from "table_2" Choose the correct SQL command that can accomplish the same.

To get all Infosys Certified Databricks Analyst Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee