join

(redirected from joins)
Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, Idioms.

join

[jȯin]
(computer science)
A portion of a robotic control program that directs an activity to resume after it has been interrupted.
(mathematics)
The join of two elements of a lattice is their least upper bound.

join

(database)
inner join (common) or outer join (less common).

join

(theory)

join

In relational database management, to match one table (file) against another based on some condition creating a third table with data from the matching tables. For example, a customer table can be joined with an order table creating a table for all customers who purchased a particular product.

The default type of join is known as an "inner" join. It produces a resulting record if there is a matching condition. For example, matching shipments with receipts would produce only those shipments that have been received. On the other hand, an "outer" join using that example would create a record for every shipment whether or not it was received. The data for received items would be attached to the shipments, and empty, or null, fields would be attached to shipments without receipts.


A Simple Join
This example matches the sales table against the product table based on product number to derive the product description.
References in periodicals archive ?
Tokyo, Japan, June 5, 2006 - (JCN Newswire) - Japan Airlines (JAL) will become part of oneworld(TM) in early 2007, after accepting today a formal letter of invitation to join the world's leading quality global airline alliance.
On ``Crossing Jordan,'' Lorraine Toussaint (Lifetime's ``Any Day Now'') joins the fun as an aggressive coroner who lives just to annoy medical examiner Jordan Cavanaugh (Jill Hennessy), who lives just to annoy us.
He joins Insignia/ESG after four years with the Equis Corporation, where he represented such clients as Coca-Cola Enterprises, State Farm Mutual Automobile Insurance Company, and Clarke Bardes Consulting.
Willetts, who will lead the group's rapidly expanding Midwest practice, which serves private equity firms, hedge funds and corporate acquirers, joins managing directors Nick Alvarez, Jack McCarthy and Paul Aversano, the three other national practice leaders who are based in New York.
Jones joins Liberty with more than a dozen years of experience in commercial real estate development, leasing, and asset management.
The Big West joins with the WAC and Pac-10 in forming the Mountain Pacific Sports Federation in water polo, wrestling, men's volleyball, men's gymnastics, men's and women's soccer and men's and women's indoor track and field.
We are very pleased to have both Tony and Doug join our organization.
Murphy joins Burbank-based Disney after serving as president of EMI's Angel Records, a classical recordings label.
Anthony Houston joins Fitch as a Director in the U.
Wojcik joins CIT with more than 20 years of sales and financing experience.
CURRAN JOINS SKOPOS: Ruth Curran recently joined Skopos Consulting as a principal consultant.
Porter Joins Proskauer Rose as Counsel (sted Timothy L.