cross join

cj(leftTable, rightTable)

leftTable and rightTable are the tables to be joined.

select column_name(s)
from leftTable cross join rightTable

Return the Cartesian product of two tables. If the left table has n rows and the right table has m rows, then the cross join function returns n*m rows.

a = table(2010 2011 2012 as year)
b = table(`IBM`C`AAPL as Ticker);
a;

b;

cj(a,b);

select * from cj(a,b) where year>2010;
// equivalent to `select * from a cross join b where year>2010`

In contrast, join simply merges two tables' columns

join(a,b);