Join vs Aggregate - What's the difference?
join | aggregate |
To combine more than one item into one; to put together.
To come together; to meet.
* (William Shakespeare) (1564-1616)
To come into the company of.
*
, title=(The Celebrity), chapter=4
, passage=No matter how early I came down, I would find him on the veranda, smoking cigarettes, or otherwise his man would be there with a message to say that his master would shortly join me if I would kindly wait.}}
To become a member of.
* , chapter=22
, title= (computing, databases, transitive) To produce an intersection of data in two or more database tables.
To unite in marriage.
* (John Wycliffe) (1320-1384)
* Bible, (w) xix. 6
(obsolete, rare) To enjoin upon; to command.
* (William Tyndale) (1494-1536)
To accept, or engage in, as a contest.
An intersection of piping or wiring; an interconnect.
(computing, databases) An intersection of data in two or more database tables.
(algebra) The lowest upper bound, an operation between pairs of elements in a lattice, denoted by the symbol .
A mass, assemblage, or sum of particulars; something consisting of elements but considered as a whole.(rfex)
A mass formed by the union of homogeneous particles; – in distinction from a compound, formed by the union of heterogeneous particles.(rfex)
(mathematics, obsolete) A set (collection of objects).
(music) The full chromatic scale of twelve equal tempered pitches.
(roofing) Crushed stone, crushed slag or water-worn gravel used for surfacing a built-up roof system.
Solid particles of low aspect ratio added to a composite material, as distinguished from the matrix and any fibers or reinforcements, especially the gravel and sand added to concrete. (technical)
Formed by a collection of particulars into a whole mass or sum; collective; combined; added up
Consisting or formed of smaller objects or parts.
Formed into clusters or groups of lobules.
(botany) Composed of several florets within a common involucre, as in the daisy; or of several carpels formed from one flower, as in the raspberry.
Having the several component parts adherent to each other only to such a degree as to be separable by mechanical means.
United into a common organized mass; said of certain compound animals.
To bring together; to collect into a mass or sum.
To add or unite, as, a person, to an association.
To amount in the aggregate to.
As verbs the difference between join and aggregate
is that join is to combine more than one item into one; to put together while aggregate is to bring together; to collect into a mass or sum.As nouns the difference between join and aggregate
is that join is an intersection of piping or wiring; an interconnect while aggregate is a mass, assemblage, or sum of particulars; something consisting of elements but considered as a whole.As an adjective aggregate is
formed by a collection of particulars into a whole mass or sum; collective; combined; added up.join
English
Verb
(en verb)- Nature and fortune joined to make thee great.
The Mirror and the Lamp, passage=In the autumn there was a row at some cement works about the unskilled labour men. A union had just been started for them and all but a few joined . One of these blacklegs was laid for by a picket and knocked out of time.}}
- he that joineth his virgin in matrimony
- What, therefore, God hath joined together, let not man put asunder.
- They join them penance, as they call it.
- (Milton)
Synonyms
* (to combine more than one item into one) bewed, connect, fay, uniteNoun
(en noun)Antonyms
* (lowest upper bound) meetDerived terms
* antijoin * autojoin * cross join * equijoin * explicit join * implicit join * inner join * left join * natural join * outer join * right join * semijoin * theta joinaggregate
English
Noun
(en noun)Synonyms
* mass, assemblage, or sum of particulars: clusterSee also
* twelve-tone technique * serialismReferences
* DeLone et. al. (Eds.) (1975). Aspects of Twentieth-Century Music. Englewood Cliffs, New Jersey: Prentice-Hall. ISBN 0130493465, Ch. 6.Adjective
(en adjective)- aggregate glands.
Verb
(aggregat)- The aggregated soil .
- ten loads, aggregating five hundred bushels .