display | more...

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.

Log in or register to write something here or to contact authors.