I : inner join

inner join

A type of join that returns records from two tables using specified values in the join fields. For example, joining customer and order tables where the customer IDs are equal produces a result set that excludes records for customers who have no orders.

Related terms

field, join, result set, table, value

Contrast with

outer join


(c) Copyright Actuate Corporation 2011