How to Join Tables in KQL | Microsoft Defender Advanced Hunting (Part 1)
MentionsMicrosoftMicrosoft Defender
Plays from YouTube in privacy-enhanced mode — nothing loads from YouTube until you press play.
Learn the basics of joining tables with Kusto Query Language (KQL) in Microsoft Defender Advanced Hunting. Using two simple demo tables, this video explains how a shared key column links rows across tables and what happens when one key matches more than one row. It then shows the same join as a KQL query in the Advanced hunting query editor, including how the default join flavor removes duplicate rows from the left table. Learn more: https://msft.it/6051aaYzc #KQLjoins #KQLjointutorial #KustoQueryLanguage
Description from Microsoft Security.