Match 2 tables and replace all values in first table

I've found the answer,

1. using merger queries LeftOuter ( tracking table as first table, and outstanding as second table )

2. expand desired columns from outstanding table in tracking table

3. using replace value on desired column if from column expansion has a value

I don't know if there is another quick way, but this is the only way I found.

Hi gzai ,
There is another way to accomplish this:
1.Click append queries,

2.Remove duplicate rows

3.Final output

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly