Outer join Query

Question

How is the maximum number of tuples for left outer join m*n. Can anyone please provide an example?

Comments

check it !

---

in left outer join we basically have A xA \cap B) \cup A. IF there is nothing returned by the intersection then the output will produce m records. If for every record in A we have a record in B then number of tuples will be max(m,n).$

---

Thank you so much for the example! I have been at it for hours!

Answer 1

All the tuples which are there on the left-hand side will be present in the output as well.

Hence, the solution will be m*n, very simple, though Magma explained it very clearly with the sample diagram.