Sometimes we have to elaborate rows- results of a SELECT- in a way we cannot think to accomplish it with simple SQL code but we can be wrong ... SQL is pretty powerful. Let's take this case.
What we have:
Customer | Wishlist |
Customer 1 | AA11, BB22, FF92 |
Customer 2 | CC43, RR55 |
What we need:
Customer | Wished product |
Customer 1 | AA11 |
Customer 1 | BB22 |
Customer 1 | FF92 |
Customer 2 | CC43 |
Customer 2 | RR55 |