You have two tables, “Product Inventory” and “Products Sold”. The tables have the same columns and you want to combine their records. However, you want to keep the records from both tables separate and display them as distinct sets. Which SQL operation should you use in this scenario?

You have two tables, “Product Inventory” and “Products Sold”. The tables have the same columns and you want to combine their records. However, you want to keep the records from both tables separate and display them as distinct sets. Which SQL operation should you use in this scenario?

 

• ORDER BY
• GROUP BY
• UNION
• JOIN