technology medium mcq

Which SQL keyword is used to combine rows from two or more tables based on related columns?

  1. UNION
  2. JOIN
  3. MERGE
  4. COMBINE

Answer: JOIN

JOIN combines rows from multiple tables using related columns (usually primary/foreign keys). Types: INNER JOIN (matching rows), LEFT/RIGHT JOIN (all rows from one side), FULL OUTER JOIN (all rows). Essential for normalized database queries retrieving related data across tables.

Topic Database & Programming
Exam Relevance Banking, SSC JE, Railway

More Technology Questions