In relational databases, a join operation matches records in two tables. The two tables must be joined by at least one common field. That is, the join field is a member of both tables. Typically, a join operation is part of a SELECT query.
Since 1995, more than 100 tech experts and researchers have kept Webopedia’s definitions, articles, and study guides up to date. For more information on current editorial staff, please visit our About page.
ADVERTISER DISCLOSURE: SOME OF THE PRODUCTS THAT APPEAR ON THIS SITE ARE FROM COMPANIES FROM WHICH TECHNOLOGYADVICE RECEIVES COMPENSATION. THIS COMPENSATION MAY IMPACT HOW AND WHERE PRODUCTS APPEAR ON THIS SITE INCLUDING, FOR EXAMPLE, THE ORDER IN WHICH THEY APPEAR. TECHNOLOGYADVICE DOES NOT INCLUDE ALL COMPANIES OR ALL TYPES OF PRODUCTS AVAILABLE IN THE MARKETPLACE.