Kusto查询:连接多个表

Question

‎表A、表B、表C

在加入表后：TableA、TableB、TableC使用Kusto查询如何显示列的值：IsPriLoc在列中：PriLoc和IsSecLoc在SecLoc中。以下是的预期结果

预期结果

Answer 1

我做了一些假设(例如关于数据类型)，但这个查询提供了所需的结果：

在Kusto上执行的链接有助于集群

let A = datatable (GUID_PK: string, Name: string, Desc: string) [
"1", "Test1", "Desc1",
"2", "Test2", "Desc2",
"3", "Test3", "Desc3",
"4", "Test4", "Desc4",
"5", "Test5", "Desc5",
"6", "Test6", "Desc6"
];
let B = datatable (GUID_FK: string, PriLoc: string, SecLoc: string) [
"1", "PriLoc1", "SecLoc1",
"3", "PriLoc3", "SecLoc3",
"5", "PriLoc5", "SecLoc5",
];
let C = datatable (GUID_FK: string, IsPriLoc: string, IsSecLoc: string) [
"2", "TRUE", "FALSE",
"4", "FALSE", "TRUE",
"6", "TRUE", "FALSE",
];
let BC = B 
| union (
C 
| project GUID_FK, PriLoc=IsPriLoc, SecLoc=IsSecLoc);
A 
| join BC on $left.GUID_PK == $right.GUID_FK