Hi.
I was training on the KQL queries and I noticed an error.
Write multi-table queries by using Kusto Query Language
Unit 5 of 9 :Exercise - Combine table results by using the lookup operator
On this page, demonstrating the usage and better performance of lookup on table,
-->the query below should return the same results as the join kind=leftouter from the page
Write multi-table queries by using Kusto Query Language
Unit 4 of 9: Exercise - Combine table results by using the join operator
I don't know if I missed something, but I don't have the same results, and the screenshot of both pages are also showing different results :D
Join leftouter results :
Lookup screen shot :
Only the first row is identical.
Regards.