A cross join is a SQL JOIN statement that yields a Cartesian product of the two tables. The resultset will contain a total number of rows equal to Table A's rowcount * Table B's rowcount. http://en.wikipedia.org/wiki/Join_%28SQL%29