·

join (EN)
verb, noun

verb “join”

infinitive join; he joins; past tense joined; past part. joined; ger. joining
  1. to connect or combine two or more things into one
    She joined the pieces of the puzzle, revealing a beautiful landscape.
  2. to come together or meet at a point
    The two rivers join just north of the city.
  3. to become a member of a group, organization, or community
    She decided to join the local library to borrow books for free.
  4. to come into the company of someone, often to participate in an activity together
    She joined her friends at the cafe for lunch.
  5. in computing and databases, to combine data from two or more tables based on a related column between them
    We joined the Sales table with the Inventory table to get a report on products sold and remaining stock.

noun “join”

singular join, plural joins or uncountable
  1. a place where two or more things, such as pipes or wires, are connected
    The plumber worked carefully to ensure the joins between the pipes were secure to prevent any leaks.
  2. in computing and databases, the result of combining data from two or more tables based on a related column
    To get a list of all employees and their departments, we used a join between the Employee and Department tables.
  3. in algebra, the operation that finds the lowest common element that is greater than or equal to two given elements in a lattice
    In the lattice of integers under division, the join of 4 and 6 is 12, since 12 is the smallest integer that is divisible by both 4 and 6.