Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
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?
-- Regards,
Villyee Anderson
Hi Villyee,
There will be 30 recordes.
from first join you will get 25 records
second will get 30 records
-- Regards,
Vishal Waghole
Hi Villyee,
There will be 30 recordes.
from first join you will get 25 records
second will get 30 records
-- Regards,
Vishal Waghole
Hi Villyee,
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.
Hi Villyee,
After apply the join condition in table A,B & C
A Left join B then you will get 25 records
and B Right join C then you will get the 30 records
Thanks
Join (SQL) - Wikipedia, the free encyclopedia
It depends on multiple factors like:
Hi,
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 | ||||
ID | DataA | ID | DataB | ID | DataA | DataB |
1 | A | 1 | D | 1 | A | D |
2 | B | 1 | E | 1 | A | E |
3 | C | 1 | F | 1 | A | F |
2 | B | |||||
3 | C |
If there are no coincidences, in left join Table A remains the same.
Thank you all...........