Re: How can I determine whether an order is placed by VIP with VIP history table

TerenceM — Thu, 11 Aug 2022 02:29:22 GMT

Thank you very much for your prompt reply! It works!

How can I determine whether an order is placed by VIP with VIP history table

TerenceM — Wed, 10 Aug 2022 09:49:39 GMT

Hello,

I have done my research but couldn't find any similar cases.

My problem is

I have two tables, one is the sales table

Another one is the VIP History Table

What I want to do is to determine whether the order is purchased within the VIP period

So for the first order, it's not a VIP order, because the order date does not fall in the neither VIP period of the customer 12345678

On the other hand, the second order is a VVIP order, because the order date fall into the VVIP period of the customer 23456789.

Thank you in advance!

Best Regards,

Terence