Logical Question

[vanderson009]

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

[VishalWaghole · Accepted solution]

Hi Villyee,

There will be 30 recordes.

from first join you will get 25 records

second will get 30 records

-- Regards,

Vishal Waghole

[rajat2392]

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.

[Anonymous]

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

[tresesco]

Join (SQL) - Wikipedia, the free encyclopedia

It depends on multiple factors like:

•      Number of fields in column between the two tables
•      Number of field values common

[rubenmarin]

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.

[vanderson009]

Thank you all...........