# join

## Syntax

`join(X,Y)`

or `X<-Y`

## Arguments

**X** and **Y** can be scalar/vector/matrix/table.

## Details

Merge X and Y.

## Examples

If X is a scalar, Y can be a scalar/vector. The result is a vector.

```
1<-3;
// output
[1,3]
4<-1 2 3;
// output
[4,1,2,3]
```

If X is a vector, Y must be a scalar/vector. The result is a vector.

```
[1,2,3]<-4;
// output
[1,2,3,4]
[1,2,3]<-[4,5,6];
// output
[1,2,3,4,5,6]
```

If X is a matrix, Y must be a vector/matrix with the same number of rows as X. The result is a matrix with the same number of rows as X.

`1..6$2:3 <- [7,8];`

#0 | #1 | #2 | #3 |
---|---|---|---|

1 | 3 | 5 | 7 |

2 | 4 | 6 | 8 |

`(1..6$2:3) <- (7..12$2:3);`

#0 | #1 | #2 | #3 | #4 | #5 |
---|---|---|---|---|---|

1 | 3 | 5 | 7 | 9 | 11 |

2 | 4 | 6 | 8 | 10 | 12 |

If X is a table, Y must be a table or a vector with the same number of rows as X. The result is a table with the same number of rows as X.

```
a=table(1..3 as x, 4.5 6.7 8.5 as y);
a;
```

x | y |
---|---|

1 | 4.5 |

2 | 6.7 |

3 | 8.5 |

```
b=table(700 500 800 as z);
b
```

z |
---|

700 |

500 |

800 |

```
c=join(a,b);
c;
```

x | y | z |
---|---|---|

1 | 4.5 | 700 |

2 | 6.7 | 500 |

3 | 8.5 | 800 |

```
a=table(1..3 as x, `IBM`C`AAPL as y);
b=table(172.3 25 106.5 as z);
c=a<-b;
c
```

x | y | z |
---|---|---|

1 | IBM | 172.3 |

2 | C | 25 |

3 | AAPL | 106.5 |

Related function: cj (cross_join)