join


Also found in: Dictionary, Thesaurus, Medical, Legal, Acronyms, Idioms, Wikipedia.
Related to join: join 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 classic literature ?
Weston, unasked, promised to get Frank over to join them, if possible; a proof of approbation and gratitude which could have been dispensed with.
We are going to Box Hill tomorrow;you will join us.
Will you, won't you, will you, won't you, won't you join the dance?
A line, on the other hand, is a continuous quantity, for it is possible to find a common boundary at which its parts join.
My children, join your hands," said Father Ephraim.
Robert M'Lellan joins the Party- John Day, a Virginia Hunter.
But what the patron announced was not realized; the lighter imitated the movement commanded by Fouquet, and instead of coming to join its pretended friends, it stopped short in the middle of the river.
DURING the Civil War a Patriot was passing through the State of Maryland with a pass from the President to join Grant's army and see the fighting.
How, in this position of affairs, I could contrive to join the lawyer in Edinburgh, after meeting my husband in London, it was not easy to see.
But in the tenth year he comes again to join the assemblies of the deathless gods who live in the house of Olympus.
But in spite of my efforts to remain composed, my attention wandered from the drawings to the merry group, and against my better judgment my wrath rose, and doubtless my countenance lowered; for Milicent, observing that I must be tired of her daubs and scratches, begged I would join the company now, and defer the examination of the remainder to another opportunity.
The dancers followed, and all through the grounds the picnic parties left their tables to join in.