join

(redirected from joined)
Also found in: Dictionary, Thesaurus, Legal, 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.

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 ?
5 : to come or bring into close association <Both schools joined together to raise funds.
McElroy, CPP, has joined the Finance department as the Payroll Supervisor.
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.
Weymans joined Bayer in 1985 as head of the laboratory and projects in central technology polymer physics.
Lee Elder * Born July 14, 1934 in Dallas, Texas; turned pro in 1959 and joined PGA Tour in 1967; won the 1974 Monsanto Open to become the first African-American to qualify for the Masters; won $1,020,514 in official PGA Tour earnings.
Freeman joined the Board in 1977 and was named section chief in 1988.
Vision Enterprises Management, LLC announced that David Kaye has joined the firm as comptroller.
John Allsop joined NFM/Welding Engineers as sales manager, NFM/ Iddon Ltd.
Reifschneider joined the Board in 1982 as an economist in the National Income Section.
Bennardo has joined the firm as vice president of new business development.