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 ?
Would not, could not, would not, could not, would not join the dance.
The further off from England the nearer is to France-- Then turn not pale, beloved snail, but come and join the dance.
He had partaken of the homely abundance of their tables, had quaffed the far-famed Shaker cider, and had joined in the sacred dance, every step of which is believed to alienate the enthusiast from earth, and bear him onward to heavenly purity and bliss.
One, when he joined the Society, had brought with him his wife and children, but never, from that hour, had spoken a fond word to the former, or taken his best-loved child upon his knee.
Alone, a stranger, hunted, threatened, persecuted, you have done in a few short months what in all the past ages of Barsoom no man has ever done: joined together the wild hordes of the sea bottoms and brought them to fight as allies of a red Martian people."
Another recruit that joined the camp at Nodowa deserves equal mention.
And so he too joined them; and away the ship flew on, and on, and on, and once more the Simpleton looked out, and this time he saw a man carrying straw upon his back.
918-920) And Leto was joined in love with Zeus who holds the aegis, and bare Apollo and Artemis delighting in arrows, children lovely above all the sons of Heaven.
921-923) Lastly, he made Hera his blooming wife: and she was joined in love with the king of gods and men, and brought forth Hebe and Ares and Eileithyia.
Mother Atkinson, as all called their hostess, was the merriest there, and the busiest; for she kept flying up to wait on the children, to bring out some new dish, or to banish the live stock, who were of such a social turn that the colt came into the entry and demanded sugar; the cats sat about in people's laps, winking suggestively at the food; and speckled hens cleared the kitchen floor of crumbs, as they joined in the chat with a cheerful clucking.
Everyone joined in saying it, and it was a pretty sight to see the little creatures bowing their curly heads and lisping out the words they knew so well.
Pierre was sitting in the drawing-room where Shinshin had engaged him, as a man recently returned from abroad, in a political conversation in which several others joined but which bored Pierre.