JOIN explanation

[Architect]

I have used the below logic to create a join table.

tab1:
load *
inline
[
a
1,
2,
3,
4
];

inner join

tab2:
load *
inline
[
b
5,
6,
7
];

Below is the output--

Can someone please explain with logic why is so.

Thanks in advance.

[MayilVahanan · Accepted solution]

HI @Architect 

Both tables doesn't have common field, so explicitly you have used join.

In that case, it using cross join. 

If you have any common field, then its do inner join.