Which join would you use to retrieve all records from one table and matching records from another?
1Times asked
Apr 2026Last seen
Apr 2026First seen
💡 Model Answer
You would use a LEFT JOIN (or LEFT OUTER JOIN). It returns all rows from the left table and the matching rows from the right table. If there is no match, the right-side columns are NULL. The syntax is: SELECT columns FROM left_table LEFT JOIN right_table ON left_table.key = right_table.key.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500