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 ?
We've been working with ESPRE for over a year and this partnership will allow us to join forces to attack the expansive mobile collaboration market.
Initiate Systems is excited to join forces with Fujitsu Consulting, a company that brings an extensive knowledge of Canada and the pan-Canadian healthcare system to the table," said Lorraine Fernandes, senior vice president of Initiate Systems' Healthcare Practice.
Thirteen and our production partners are thrilled to join forces with him to create a resource that will be used and enjoyed on many levels by music-lovers, teachers, students, scholars, and professional musicians alike for many years to come.
For the past few years I've been looking for someone to join forces with to expand the many facets of EPE, to take it to new levels internationally, and to make it an even greater force in the entertainment industry," said Lisa Marie Presley, singer/songwriter and sole heir to the Elvis Presley Estate.
After fruitful discussion with GMRC, we are now committed to join forces and develop a strong and long lasting community of professional and academics in middleware in South China.
We are pleased to join forces with MfgQuote to offer this new quoting service at no charge to our customers," said Robert McGill, SolidWorks director of business alliances.
The very rapid extension of our roster of production-ready, high quality components is made possible by our organization as a multilateral home ground for professional open-source projects where companies join forces to implement open standards, create software commons and share best practices," said Jean-Pierre Laisne, ObjectWeb Chairman and Linux & Open Source Strategy Manager for Bull.