join questions

%3CLINGO-SUB%20id%3D%22lingo-sub-131765%22%20slang%3D%22en-US%22%3Ejoin%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131765%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.Is%20it%20possible%20to%20join%202%20tables%20without%20a%20common%2Fshared%20column%3F%3C%2FP%3E%0A%3CP%3E2.%20Is%20it%20possible%20to%20create%20a%20join%20inside%20a%20join%3F%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-131765%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-136350%22%20slang%3D%22en-US%22%3ERe%3A%20join%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136350%22%20slang%3D%22en-US%22%3ESee%20few%20example%20in%20this%20article%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.loganalytics.io%2Fdocs%2FLearn%2FTutorials%2FJoins---cross-analysis%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.loganalytics.io%2Fdocs%2FLearn%2FTutorials%2FJoins---cross-analysis%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133750%22%20slang%3D%22en-US%22%3ERe%3A%20join%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133750%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20you%20please%20write%20an%20example%20for%20join%20inside%20a%20join%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-133743%22%20slang%3D%22en-US%22%3ERe%3A%20join%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-133743%22%20slang%3D%22en-US%22%3E%3CP%3ECool!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131832%22%20slang%3D%22en-US%22%3ERe%3A%20join%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131832%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3E1.%3CBR%20%2F%3EYou%20always%20need%20to%20provide%20a%20common%20column%20but%20you%20can%20create%20a%20fabricated%20column%20that%20would%20simulate%20what%20you%20would%20like%20to%20achieve.%20For%20example%3A%3CBR%20%2F%3ETable1%20%3CBR%20%2F%3E%7C%20extend%20dummy%3D1%20%3CBR%20%2F%3E%7C%20join%20(%3CBR%20%2F%3E%20Table2%3CBR%20%2F%3E%20%7C%20extend%20dummy%3D1%3CBR%20%2F%3E)%20on%20dummy%20%3CBR%20%2F%3E%3CBR%20%2F%3E2.%3CBR%20%2F%3ESure!%20I%20do%20this%20all%20the%20time%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E
Occasional 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?