join

(redirected from joins)
Also found in: Dictionary, Thesaurus, Medical, Legal, Financial, 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 classic literature ?
But it ain't often either that a man comes along with a cabload of things to join a ship at this time of night.
She had no desire to sleep or to retire; nor did she feel like going over to sit with the Ratignolles, or to join Madame Lebrun and a group whose animated voices reached her as they sat in conversation before the house.
Woodhouse, as well as Emma, to join the party; and he knew that to have any of them sitting down out of doors to eat would inevitably make him ill.
She returned just in time to join the others as they quitted the house, on an excursion through its more immediate premises; and the rest of the morning was easily whiled away, in lounging round the kitchen garden, examining the bloom upon its walls, and listening to the gardener's lamentations upon blights, in dawdling through the green-house, where the loss of her favourite plants, unwarily exposed, and nipped by the lingering frost, raised the laughter of Charlotte,--and in visiting her poultry-yard, where, in the disappointed hopes of her dairy-maid, by hens forsaking their nests, or being stolen by a fox, or in the rapid decrease of a promising young brood, she found fresh sources of merriment.
Will you, won't you, will you, won't you, will you join the dance?
The Portuguese unadvisedly engaged themselves in an enterprise, to march through the whole country, in order to join the Emperor, who was then in the most remote part of his dominions.
Let all our neighbors know that we shall join with them to oppose aggression or subversion anywhere in the Americas.
The jailers had all left to join the fighters in the throne room, so we searched the labyrinthine prison without opposition.
For example: two fives make ten, but the two fives have no common boundary, but are separate; the parts three and seven also do not join at any boundary.
He was directly invited to join their party, but he declined it, observing that he could imagine but two motives for their choosing to walk up and down the room together, with either of which motives his joining them would interfere.
He sought an interview with Martha, and proposed that they should join the Society of Shakers.
Hurrying on by long marches, they at length fell upon a trail, which, with the experienced eye of veteran woodmen, they soon discovered to be that of the party of trappers detached by Captain Bonneville when on his march, and which they were sent to join.