Thank you James! After looking through the tables, I joined transaction.shippingaddress = transactionShippingAddress.nkey & got the result that matches my records, but thanks for the assistance! Sometimes something is right in front of you but you can't see it without help.