Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
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?
First you are doing Right Join B - C.... There are 30 records..... drop table C..
Now A - B left join... Drop table B... 25 records...
I think it depends on the values of the fields used for the joins.
Are they all distinct?