join


Also found in: Dictionary, Thesaurus, Medical, Legal, Acronyms, Idioms, Wikipedia.
Related to join: join up

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 ?
Since being invited to join oneworld, Royal Jordanian has signed contracts for five new IT systems to enable it so deliver the alliance's services and benefits, and moved its operations at Paris from Orly to CDG, to operate alongside its partners.
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.
July 8, 1996 - Cal State Northridge and Sacramento State join the conference in softball only.
Todd Matherne joins FTI Palladium Partners, the interim management arm of FTI's Corporate Finance practice, as senior managing director in FTI's Houston office.
Murphy joins Burbank-based Disney after serving as president of EMI's Angel Records, a classical recordings label.
Maura McGuigan joins Fitch as a Director in Fitch's Public Finance, Tax Exempt Housing group, focusing on Military Housing, State Housing Finance Agency (HFA) debt, and other housing related transactions.
Porter Joins Proskauer Rose as Counsel (sted Timothy L.
Hawley joins The Schultz Organization from Levin Management, where she was director of leasing.
Kevin Shultz joins FTI Capital Advisors, LLC, Terry Orr joins the FTI Forensic and Litigation Consulting practice, Craig Earnshaw joins the FTI Technology practice and Bruce Benson joins the FTI Economic Consulting practice.
Gazzola joins Paine/Wetzel from Leopardo Companies, Inc.
Cullinan, who has more than 10 years of commercial real estate experience, joins his new firm after serving as a member of the capital advisors group at Insignia/ESG.