1

What is the the result of natural join if two relations have exactly the same attributes? That is suppose

A B A B

1 2 7 8

3 4 9 10

5 6 1 2

Would the result just be

A B

1 2

Mat.S
  • 1,814
  • 7
  • 24
  • 36
  • 1
    Your answer is correct. For extra credit, what is the result of natural join if the two relations have *no* attributes in common? – nvogel Oct 20 '13 at 20:38
  • 1
    The Cartesian product. – Mat.S Oct 23 '13 at 14:57
  • That's right. Product is just a special case of Natural Join. – nvogel Oct 23 '13 at 15:11
  • Possible duplicate of [Difference between a theta join, equijoin and natural join](https://stackoverflow.com/questions/7870155/difference-between-a-theta-join-equijoin-and-natural-join) – philipxy Jun 06 '18 at 19:42

0 Answers0