join questions

Copper Contributor

Hello

 

1.Is it possible to join 2 tables without a common/shared column?

2. Is it possible to create a join inside a join? 

 

Thanks

4 Replies
Hi,

1.
You always need to provide a common column but you can create a fabricated column that would simulate what you would like to achieve. For example:
Table1
| extend dummy=1
| join (
Table2
| extend dummy=1
) on dummy

2.
Sure! I do this all the time :)

Cool!

 

Thank you

can you please write an example for join inside a join?