What does a JOIN operation do in SQL? A. To delete unnecessary data
B. To modify table structures
C. To create new database users
D. To combine data from related tables
What does a JOIN operation do in SQL?
Share
The correct answer is: D. To combine data from related tables.
A JOIN operation in SQL is used to retrieve data from two or more tables based on a related column between them. It allows you to combine rows from these tables, making it easier to analyze and work with interconnected data. For instance, if you have a table for customers and another for orders, you can use a JOIN to get customer information alongside their orders. If you need further clarification or examples, feel free to ask!