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 :-)
Cool!
Thank you