Second left Join not populating table

[slamster44]

I am joining two different tables back to a master table and trying to populate a new field called "Bucket"

When I join the first table (Invoices), it populates the Bucket column with the correct data

When I join the second table (Payments), it populates Bucket as null value.

I also am joining the Payments back to itself to see if the column is populating and it is.

Why is my second join not working?

[dplr-rn]

As i see it. you are joining on same table Transactions twice to populate same column Aging. but second join essentially messes with first one because the column Bucket is already there.

Create 1 table with TranNo and Bucket (concatenate date from both Invoice and Payments) . And perform 1 left join