Join: Inner/Outer left/right?

dragoljub
dragoljub New Altair Community Member
edited November 5 in Community Q&A
I am slightly confused by the join operator.

There are 4 types. For clarity what does each join type preform?

When only adding attributes to a small number of samples to a large group should 'outer' or 'left/right' be used?

???

Thanks,
-Gagi
Tagged:

Answers

  • land
    land New Altair Community Member
    Hi,
    I think these types are equivalent to what is used in the database domain. Please take a look at http://en.wikipedia.org/wiki/Join_(SQL).

    Greetings,
      Sebastian
  • dragoljub
    dragoljub New Altair Community Member
    Thanks this makes sense.

    Inner Join = Only add attributes for matching IDs (intersection of IDs) (may remove some samples)

    Left/Right Join = Only adds attributes to samples contained in the left/right data sets (keeps all samples from left or right) (can add missing values)

    Outer Join = Joins all records from both datasets and adds missing values for attributes not shared between samples.

    Hope this helps someone. Maybe we should add a wiki link in the help of this operator.

    -Gagi

Categories