170 ) 10 ) customers Historical addresses

 

================================================================

10 ) customers Historical addresses  

================================================================

Note : ( for this "order"table should save the delivery address also )

 ================================================================

SELECT

    o.OrderID,
    o.CustomerID,
    o.OrderDate,
    o.DeliveryAddress AS OrderDeliveryAddress,
    c.CustomerName
FROM 
    [order] o
JOIN 
    customer c ON o.CustomerID = c.CustomerID;
================================================================

Sample Output

OrderID	CustomerID	OrderDate	OrderDeliveryAddress	CustomerName
101	1	2026-06-01	123 Main St, New York, NY	Alice Smith
102	1	2026-06-18	999 New Pine Rd, Boston, MA	Alice Smith
103	2	2026-06-20	456 Oak Rd, Austin, TX	Bob Jones