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.
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.