In SQL, an inner join is one in which you select the rows from both tables that match some specified criteria.
The syntax is usually something like:
SELECT * FROM a INNER JOIN b ON a.field=b.field
Inner joins are also sometimes called "equi-joins" or "natural joins".
Compare with join (cross join) and outer join.