A Cartesian product is the result of an unrestricted join of two or moretables. The result set of a three table Cartesian product will have x *y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join.