In SQL, a "Cartesian product" refers more specifically to a result set which contains all the permutations of rows of Table A with rows of Table B (and Table C, etc...).

If the result set of your SQL query returns far more rows than anticipated (more even than any of your source tables have), check your join conditions; chances are you've inadvertently created a Cartesian product.