can anyone explain the output for below left join…..

[aggaman]

company1: 

load * inline[ 

a,

1,

1,

1];

company2:

left join  load * inline [
a,

1,

1];

[aggaman]

hi the output for above left join is ….

a

1

1

1

1

1

1

can anyone explain the logic of left join behind this?

[anat]

you have 3 records in company1 table and 2 records in company2 tables

so when you do the left join you will get 3*2=6 records as per your scenario

[Hania]

Hii @aggaman ,

Here is the answer of your question 

Hope this massage helpful.

[aggaman]

Hi @Hania @anat 
can you please explain the logic for the above output in reference to left join