In SQL, a join (or cross join) between two tables (A and B) is when you match up each and every line (tuple) in the first table with each and every line in the second. So in this case, the join would create a table (temporarily at least) that is A x B lines long.
Compare with inner join and outer join.