Home

join questions

Highlighted
Tal Feinberg
New Contributor

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

4 Replies

Re: join questions

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 :-)

Re: join questions

Cool!

 

Thank you

Re: join questions

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

 

Re: join questions