[donnaf]

I need to created a saved search where I find any customers who have used a promotion but also show all other orders they have placed.

In regular sql it would be something like – Select * from sales_file where customer in(select customer from so_file where promotion = "desired_promotion"
This is a cached copy. Click here to see the original post.

[Author]

Posts