There is three tables-A with 25 records,
B with 15 records and C with 30 records.
And you are doing Left Join Between A and B,
right join between B and C . What would be the end result?
It depends on the column common between the tables.
If there is no common column, then it becomes a cartesian product. First join will result in 25x15=375 rows and Second join will result in 30x15=450 rows.
If there is a common column between the tables, then
First join will result 25 rows
Second Join will result in 30 rows.
You can know that the minimum will be 30 rows, in case there are no coincidences between tables. In other case it depends on coincidendes...
|Table A||Table B||Result|
If there are no coincidences, in left join Table A remains the same.