Merge two tables in Power query

let
Source1 = #"Append2-Nov-23 (2)",
Source2 = #"Merge2(2)-Nov-23",
MergedTable = Table.NestedJoin(Source1, {"Emp ID", "Merged Work order numbers"}, Source2, {"Emp ID", "Work Order Number"}, "MergedData"),
ExpandedTable = Table.ExpandTableColumn(MergedTable, "MergedData", {"CTC Owner"})
in
ExpandedTable


i have used this, but this is only partially working, in this formula only EMP ID is common between two tables, work order numbers some available in first table are not there in second table, but all the work order numbers in second table are available in the first table. CTC owner is showing for only those work orders which are there in the first table correctly, for others wrong owner name is showing