D
dhstein
I'm not looking for the exact syntax here - just an idea of what the SQL
statement might look like. The situation is we have a table of invoices.
Each invoice has a customer name, a list of products purchased, and a date of
the invoice. We want to find the customer names who have purchased a
specific item - for example Black Sneakers - but the purchase was not the
first time the customer made a purchase - maybe last time they purchased blue
sandals. So the item has to appear on a customer invoice but the customer
had purchased some other items on a previous invoice. So the query would
provide the list of RETURNING customers who are purchasing black sneakers.
Thanks for any help on this.
statement might look like. The situation is we have a table of invoices.
Each invoice has a customer name, a list of products purchased, and a date of
the invoice. We want to find the customer names who have purchased a
specific item - for example Black Sneakers - but the purchase was not the
first time the customer made a purchase - maybe last time they purchased blue
sandals. So the item has to appear on a customer invoice but the customer
had purchased some other items on a previous invoice. So the query would
provide the list of RETURNING customers who are purchasing black sneakers.
Thanks for any help on this.