HomeInterview QuestionsWhich key would you use to join tables?

Which key would you use to join tables?

🟢 Easy Conceptual Fresher level
1Times asked
Apr 2026Last seen
Apr 2026First seen

💡 Model Answer

To join two tables you use a column that exists in both tables and uniquely identifies the relationship. Typically this is a primary key in one table and a foreign key in the other. For example, if you have a Customers table with CustomerID as the primary key and an Orders table with CustomerID as a foreign key, you would join on Customers.CustomerID = Orders.CustomerID.

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