join

(redirected from joined)
Also found in: Dictionary, Thesaurus, Idioms, Wikipedia.
Related to joined: joined 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.
McGraw-Hill Dictionary of Scientific & Technical Terms, 6E, Copyright © 2003 by The McGraw-Hill Companies, Inc.

join

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

join

(theory)
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

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.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
Carolyn Philpot has joined Beall Barclay Wealth Management LLC in Fort Smith as financial adviser.
Bill Madden, CPA, joined the FEI Research Foundation team as a researcher.
He joined Northwestern Mutual in 1977 as an attorney and was promoted to vice president in 1993.
Coleman joined Ford in 1987 as an area manager, and progressed to plant manager of the Ohio assembly plant.
Having evaluated different cities and opportunities, Marissa joined Mark David & Company in November 2004.
Killian joined the Board in 1993 and was employed in the Board's Office of Inspector General before moving to DCCA as a manager in 1998.
(John) Pizzey has joined the Amcor board of directors.
In a joint release on April 26, in conjunction with the FEI/AICPA conference, FEI joined with the National Investor Relations Institute to issue best practices guidelines for company-issued earnings press releases -- in particular, those dealing with "pro forma" numbers.
Morgan, a 30-year veteran of the insurance industry, joined Berkshire Life in October 1999 as senior underwriter and was elected an officer and made director of underwriting in April 2000.
Mark Burtschi joined Goodyear Tire & Rubber as director of federal and state affairs in the company's Washington, D.C.
In contrast, a trial in which the issues have been properly narrowed and joined will provide the court with a road map through the record.