Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone explain me how it works.
T1:
load * inline [
ID
1
1 ];
T2:
load * inline [
ID
1
1
1
1 ];
and when we join them, whether it is inner,outer,left or right, the result is
ID
1
1
1
1
1
1
1
1
and for concatenate we get
ID
1
1
1
1
1
1
please tell me how this works, thank you.
I guess concatenation is pretty simple and that doesn't require an explanation. I would try to explain the JOIN result. The basic of join is where there is a match for EVERY elements it would be taken into result table. So for your first table - 1 (one) is there twice, therefore, for every 1 - it matches with all the four 1's in the second table, so essentially for two 1's it would generate 2x4=8, i.e. eight 1's, and that is what you get as output.
Hope this helps.
I guess concatenation is pretty simple and that doesn't require an explanation. I would try to explain the JOIN result. The basic of join is where there is a match for EVERY elements it would be taken into result table. So for your first table - 1 (one) is there twice, therefore, for every 1 - it matches with all the four 1's in the second table, so essentially for two 1's it would generate 2x4=8, i.e. eight 1's, and that is what you get as output.
Hope this helps.
Thank You