join

(redirected from join forces)
Also found in: Dictionary, Thesaurus, Legal, Idioms.
Related to join forces: Canadian armed forces

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 ?
Diana West, Walsall Council countryside services senior ranger, said: "The two groups worked together very well before and we are keen to see them join forces again.
I am excited to join forces with Buddy Berk, a seasoned pharmaceutical executive, in building Novel Laboratories, a new research-based specialty pharmaceutical company," said Veerappan Subramanian, Ph.
Photo Former bigwigs of espionage join forces in Spycraft The Great Game to be released on CD-ROM.
MINNEAPOLIS -- As an important step in its strategic plan to become the leading worldwide provider of accounting, tax and business consulting services to midsized companies, RSM McGladrey (NYSE: HRB) has announced plans to join forces with UK-based RSM Robson Rhodes.
Per the agreement, ESPRE and Anyware will join forces to meet the growing demand for video-centric mobile business solutions.
Commenting on the partnership, Kent Heyman, CEO of Migo Software, said, "Migo Software is pleased to join forces with TSR Storage.
The Automotive Dealership Institute has agreed to join forces with Dealership for Life, a nationwide dealership customer loyalty and retention program, it was announced by ADI CEO Alan Algan and DFL CEO Jeff Buchanan.