Select o.Email,
o.Subscriber_Key as Subscriberkey,
o.Signup_Date,
o.Total_Orders,
o.Oberlo_Account_ID,
o.Last_Order_Received_Date,
m.[First Name]
From "Production" as o
Inner Join [Master List] as m
ON m.Email = o.Email
WHERE DATEDIFF(day,Last_Order_Received_Date,GETDATE()) <= 30