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 ?
940-942) And Semele, daughter of Cadmus was joined with him in love and bare him a splendid son, joyous Dionysus, -- a mortal woman an immortal son.
943-944) And Alemena was joined in love with Zeus who drives the clouds and bare mighty Heracles.
Another recruit that joined the camp at Nodowa deserves equal mention.
Said he thanked the whiting kindly, but he would not join the dance.
Would not, could not, would not, could not, would not join the dance.
"My children, join your hands," said Father Ephraim.
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."
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.
As Aramis told me to come before the equinox, you have understood that that was to join him.
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.
"If any opportunity falls in your way after you have taken the house, and before we join you, of exchanging a few civil words either with Mr.
Joshua Rann, having a slight touch of rheumatism, did not join in the ringing of the bells this morning, and, looking on with some contempt at these informal greetings which required no official co-operation from the clerk, began to hum in his musical bass, "Oh what a joyful thing it is," by way of preluding a little to the effect he intended to produce in the wedding psalm next Sunday.