Cross Join (CROSS JOIN): Returns the Cartesian Product of two or more tables.
SELECT E.name, S.name
FROM (
EMPLOYEE E
CROSS JOIN EMPLOYEE S
)Cross Join (CROSS JOIN): Returns the Cartesian Product of two or more tables.
SELECT E.name, S.name
FROM (
EMPLOYEE E
CROSS JOIN EMPLOYEE S
)