There are two tables, TableA and TableB, each with a column called 'call'. Write an inner join query and describe the output.
1Times asked
Jul 2026Last seen
Jul 2026First seen
💡 Model Answer
The inner join will return only rows where the 'call' value exists in both tables. The query:
SELECT a.call, b.call
FROM TableA AS a
INNER JOIN TableB AS b
ON a.call = b.call;
If TableA has calls 1,2,3 and TableB has calls 2,3,4, the result will be rows (2,2) and (3,3). All other combinations are omitted because they have no match in the other table.
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 on a discreet on-screen overlay.
Get Assisting AI — Starts at ₹500