let
    Table1 = #table({"ID", "Name"}, {{1, "Alice"}, {2, "Bob"}}),
    Table2 = #table({"ID", "Dept"}, {{1, "HR"}, {3, "IT"}}),
    Result = Table.NestedJoin(
        Table1, {"ID"},
        Table2, {"ID"},
        "Details",
        JoinKind.LeftOuter
    )
in
    Result