inner join

from The Free On-line Dictionary of Computing (8 July 2008)

inner join

   <database> (Commonly "join", but see also "{outer join}") A
   {relational database} operation which selects rows from two
   {tables} such that the value in one {column} of the first
   table also appears in a certain column of the second table.

   An example in {SQL}:

   	select * from A, B
   	where A.x = B.y

   The column names (x and y in this example) are often, but not
   necessarily, the same.

   (1998-11-23)