Select
a.Customer_Id,
a.Email_Address,
a.First_Name,
a.Delivery_Address_Postal_Code,
a.Delivery_Address_Town,
b.Product_Code
from Master_Customer_Active a
join Master_Order o
on a.Customer_Id = o.Customer_Id
join Master_Order_Line_Item b
on b.Order_Id = o.Order_Id