Sunday, 11 November 2012

Are the resulting relations of PRODUCT and JOIN operation the same?


No.
PRODUCT: Concatenation of every row in one relation with every row in another.
JOIN: Concatenation of rows from one relation and related rows from another.

No comments: