If more than one relation is specified in the FROM-clause and there is no join condition, then the Cartesian product of tuples is selected.
SELECT SSN, DNAME FROM EMPLOYEE, DEPARTMENTIf more than one relation is specified in the FROM-clause and there is no join condition, then the Cartesian product of tuples is selected.
SELECT SSN, DNAME FROM EMPLOYEE, DEPARTMENT