I am trying to run a query where I would like to find users whose last order received date is within last 30 days.
NOTE - Here I am using an inner join only to get the "First Name" field from a data extension called 'Master List'
The query validation was successful but didn't run successfully, can you please help me what I am doing wrong over here?
Query below -
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