cj
Syntax
cj(X, Y)
Arguments
X and Y are tables.
Details
Perform a cross join between two tables and returns their Cartesian product. If X has n rows and Y has m rows, then cj(X,Y) has n*m rows.
Examples
a=table(1..3 as x,`IBM`C`AAPL as y)
b=table(172.3 25 106.5 as z)
c=cj(a,b);
c;
x | y | z |
---|---|---|
1 | IBM | 172.3 |
1 | IBM | 25 |
1 | IBM | 106.5 |
2 | C | 172.3 |
2 | C | 25 |
2 | C | 106.5 |
3 | AAPL | 172.3 |
3 | AAPL | 25 |
3 | AAPL | 106.5 |
// in contrast, the join (<-) operation simply merges two tables' columns
a join b;
x | y | z |
---|---|---|
1 | IBM | 172.3 |
2 | C | 25 |
3 | AAPL | 106.5 |