What's the difference between
and
Enter two words to compare and contrast their definitions, origins, and synonyms to better understand how those words are related.

Join vs Aggregate - What's the difference?

join | aggregate |

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)
  • To combine more than one item into one; to put together.
  • To come together; to meet.
  • * (William Shakespeare) (1564-1616)
    • Nature and fortune joined to make thee great.
  • 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= 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.}}
  • (computing, databases, transitive) To produce an intersection of data in two or more database tables.
  • To unite in marriage.
  • * (John Wycliffe) (1320-1384)
    • he that joineth his virgin in matrimony
  • * Bible, (w) xix. 6
    • What, therefore, God hath joined together, let not man put asunder.
  • (obsolete, rare) To enjoin upon; to command.
  • * (William Tyndale) (1494-1536)
    • They join them penance, as they call it.
  • To accept, or engage in, as a contest.
    • (Milton)

    Synonyms

    * (to combine more than one item into one) bewed, connect, fay, unite

    Noun

    (en noun)
  • 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 .

    • Antonyms

    * (lowest upper bound) meet

    Derived terms

    * antijoin * autojoin * cross join * equijoin * explicit join * implicit join * inner join * left join * natural join * outer join * right join * semijoin * theta join

    aggregate

    English

    Noun

    (en noun)
  • 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)

    • Synonyms

    * mass, assemblage, or sum of particulars: cluster

    See also

    * twelve-tone technique * serialism

    References

    * DeLone et. al. (Eds.) (1975). Aspects of Twentieth-Century Music. Englewood Cliffs, New Jersey: Prentice-Hall. ISBN 0130493465, Ch. 6.

    Adjective

    (en adjective)
  • 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.
    • aggregate glands.
  • (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.

    • Verb

    (aggregat)
  • To bring together; to collect into a mass or sum.
    • The aggregated soil .
  • To add or unite, as, a person, to an association.
  • To amount in the aggregate to.
    • ten loads, aggregating five hundred bushels .

    Antonyms

    * segregate

    References

    * English heteronyms ----