join

(redirected from joined forces)
Also found in: Dictionary, Thesaurus, Legal.
Related to joined forces: 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 ?
Officers from major agencies have joined forces to see how they can better work together to tackle problems such as fly-tipping, noisy neighbours, drug taking and vandalism.
THE mothers of missing estate agent Suzy Lamplugh and Lucie Blackman, the former air hostess murdered in Japan, have joined forces to launch a travel safety guide for young people.
The ICPAS and AICPA recently joined forces to spotlight the importance of sound investment and risk management strategies and the CPA's role in this capacity.
In addition, the Ethics and Religious Liberty Commission of the Southern Baptist Convention joined forces with the Family Research Council and the National Association of Evangelicals to file a pro-voucher brief.
Emic Networks, the leading provider of clustering solutions for building mission critical applications using open source components, announced today its membership in ObjectWeb, a consortium of companies and research organizations who have joined forces to produce next-generation open source middleware.
After learning about Chiropractic USA, more and more leaders of the Chiropractic community have joined forces with us, eager to get involved in our growing nationwide movement.
A group of more than seventy-five physicians and healthcare professionals joined forces with a group of technologists to develop a suite of integrated, physician-centric software solutions designed to meet the healthcare industry's demand for dependable, HIPAA-era management software solutions.
Cancer program, Coach Stewart joined forces with the CCA because of similar goals -- to help limit the number of deaths caused by cancer.
and MAAC Machinery have joined forces to develop and manufacture the Royce Router, a new brand of routers that are nearly four times faster than the industry standard.
We are honored to have joined forces with the Mississippi Governor's office and Kelly Services in a concerted effort to help the people of Mississippi impacted by Hurricane Katrina find employment and begin the process of rebuilding their lives" said Andrew J.
GRENOBLE, France -- ObjectWeb, an international nonprofit consortium of companies and research organizations who have joined forces to produce next-generation open source middleware, today announced the creation of Petals, a project targeting the development of an ObjectWeb Java(tm) Business Integration (JBI) platform.