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 | 
