join

(redirected from join forces)
Also found in: Dictionary, Thesaurus, 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 ?
Earlier, another insider said as quoted by the news agency that Apax had held talks with Santander to join forces to acquire another Polish bank, Bank Zachodni WBK (WAR:BZW).
"We can be more effective in Africa, Central Asia and the Middle East if we join forces with Turkey.
Sir Alex Ferguson will join forces with Manchester United legend Sir Bobby Charlton to impress the FIFA team inspecting England's 2018 World Cup bid.
BEIRUT: Senior Shiite cleric Sayyed Mohammad Hussein Fadlallah said on Sunday that the situation in Palestine "is more critical than any previous period." Speaking to a delegation from Hamas headed by Ali Barakah, Fadlallah urged all Palestinian factions to join forces to resist and counter Israeli aggression and theft of their land.
Ahmed Abdelshafi Toba, chairman of one faction, said issues of leadership were not part of the agreement but would be discussed once all groups agree to join forces.
Becoming more efficient was a critical factor in the decision to join forces, Blome agrees.
TWILIGHT S/t (Southern Lord)--All-(dark)-star line-up of blackened grimmsters (Xasthur, Leviathan, Draugar, Nachtmystium and Krieg) join forces to create one dominating entity of bleak terror.
The attorneys, whose areas of specialty include real estate, corporate law and litigation, will join forces with Seyfarth Shaw's expanding New York presence in accomplished real estate, tax, corporate law, labor and employment law and litigation.
Worldwide Computer Products News-11 April 2005-Symantec and Blue Coat join forces to supply new package(C)1995-2005 M2 COMMUNICATIONS LTD http://www.m2.com
TELECOMWORLDWIRE-11 April 2005-Symantec and Blue Coat join forces to supply new package(C)1994-2005 M2 COMMUNICATIONS LTD http://www.m2.com
(DSSI), Rochester, New York have agreed in principle to join forces to launch a line of high-quality security papers for general office use.