Tweet
I'm trying to create a Smart List where I send an email to customers who have purchased items in a specific category. The current SmartList only allows sending to customers who have purchased a specific product. Is there anyone who can help me tweak the SQL?
The Product SQL is:
select distinct oemail as email from orders left join oitems on orders.orderid=oitems.orderid where (oitems.itemid=[field1] AND orders.order_status NOT IN (5,7,11,12) and odate>=[field2] and odate<=[field3])
Any help/guidance would be appreciated. Marlene
The Product SQL is:
select distinct oemail as email from orders left join oitems on orders.orderid=oitems.orderid where (oitems.itemid=[field1] AND orders.order_status NOT IN (5,7,11,12) and odate>=[field2] and odate<=[field3])
Any help/guidance would be appreciated. Marlene
Comment