You need to reconcile customer profile data coming from SmartDollar and EveryDollar. The same customer_id may exist in both systems, and the latest record inside each source is not always the same across sources. Your query should return one resolved row per customer, preserve customers found in only one system, choose attribute values using recency-based conflict resolution, and expose which source supplied each final value.