inner join(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)