join

(redirected from joined up)
Also found in: Dictionary, Thesaurus, Legal, 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 ?
Graduating with a bachelor's degree in Engineering Physics, he joined UPS in the mid-1980s and soon began learning the value of fine-grained process thinking--every process codified, communicated, understood, and replicated across the company.
Davis joined UPS in 1986 when the company acquired II Morrow, where he served as chief financial officer and chief executive officer.
After a brief stint as an accountant, the Jersey City, NJ, native joined UPS in 1964 as a delivery driver, after earning a B.
Since 1988, when she joined UPS, no passengers have given her funny looks or refused to fly with her.
The state has joined UPS to deliver 60,000 UNICEF emergency supply kits.
Foster joined UPS in 2011 and currently leads processes related to UPS'Access Point[TM] and the Transportation Sourcing group.
He joined UPS in 1964 as a package delivery driver.