How do you perform an inner join on a key?
1Times asked
Apr 2026Last seen
Apr 2026First seen
💡 Model Answer
An inner join returns only rows that have matching values in both tables. The syntax is: SELECT columns FROM table1 INNER JOIN table2 ON table1.key = table2.key. Replace 'key' with the column name that links the tables, such as CustomerID. This will give you rows where the key exists in both tables.
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