In SQL the statement select ∗ from R, S is equivalent to
2023
In SQL the statement select ∗ from R, S is equivalent to
- A.
Select ∗ from R natural join S
- B.
Select ∗ from R cross join S
- C.
Select ∗ from R outer join S
- D.
Select ∗ from R inner join S
Attempted by 319 students.
Show answer & explanation
Correct answer: B
The SQL statement SELECT * FROM R, S performs an implicit Cartesian product between tables R and S. This operation generates all possible row combinations without any filtering conditions, which is functionally identical to an explicit CROSS JOIN statement in modern SQL standards.