# Manuals/calci/JOIN

Jump to navigation
Jump to search

**JOIN (GivenSet1,GivenSet2,JoinType,JoinSets,IsFlattened)**

- and are set of numbers.

## Description

- This function is joining the set of numbers.
- In , and are any two set of numbers.
- Join Type and Join set are any positive integer value.
- Here 1st number in the 1st set is joining with the 1st number in the 2nd set.
- From the second number it is making the duplicate number compared with the 1st set one or less.
- Suppose it is two or less numbers it is joining with the first number only.
- So it is joining all the numbers in the 1st set with the 2nd set except the 1st elements from the both the sets.

## Examples

- JOIN([1,2,3],[6]) = 1 6
- JOIN([4,5,6,7],[2,4,7])

4 | 2 |

5 | 4 |

5 | 7 |

6 | 4 |

6 | 7 |

7 | 4 |

7 | 7 |

3.JOIN([10,11,12,13],[5,10])

10 | 5 |

11 | 10 |

12 | 10 |

13 | 10 |