8일차 # 5-26: CROSS JOIN (Cartesian Product)

- A join condition is omitted

  - A join condition is invalid

  - All rows in the first table are joined to all rows in the second table

select count(*) from employees;

select count(*) from departments;

  select last_name, department_name

  from employees

  cross join departments;

    160 개의 행이 선택되었습니다.

   ↓ ↓

<Oracle Syntax>

  select last_name, department_name

  from employees, departments;

oj_SQL.txt