0 votes 0 votes How is the maximum number of tuples for left outer join m*n. Can anyone please provide an example? Anilava Kundu asked Oct 31, 2018 Anilava Kundu 383 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply Magma commented Oct 31, 2018 reply Follow Share All the tuples which are present in left side of table are present in the output therefore m * n 0 votes 0 votes Anilava Kundu commented Oct 31, 2018 reply Follow Share How m*n ? If left side table contains m tuples and right contains n then if only left side tuples come there should be m tuples. Can you please give an example I can't seem to wrap my head around it. 0 votes 0 votes Magma commented Oct 31, 2018 reply Follow Share check it ! 2 votes 2 votes Tejasvi96 commented Oct 31, 2018 reply Follow Share 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).$ 0 votes 0 votes Anilava Kundu commented Oct 31, 2018 reply Follow Share Thank you so much for the example! I have been at it for hours! 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 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. `JEET answered Oct 31, 2018 `JEET comment Share Follow See all 0 reply Please log in or register to add a comment.