An INNER JOIN between TableA and TableB will return:

All rows from TableA

All rows from TableB

Only the rows where the joined fields in both tables match

All rows from both tables

The INNER JOIN keyword selects records that have matching values in both tables. It is the most common type of join.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.