Forum Discussion
join questions
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
Meir_Mendelovich
Microsoft
MicrosoftHi,
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 :-)
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 :-)
can you please write an example for join inside a join?
- Meir_MendelovichSee few example in this article: https://docs.loganalytics.io/docs/Learn/Tutorials/Joins---cross-analysis
Cool!
Thank you
