Error in demonstration KQL queries

Question

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.

Answer 1

@Olivier SANS Thanks for your patience while we were looking into this issue.

This document was updated with the correct query and result. Please check it out and let us know if this helps. If you have any further questions, please do let me know. Thank you!