title: SQL: How to have multiple product_id in a single sales_id without separating products using delimiters?
body: <p>In the requirements given to me, multiple products can be assigned to a single sale. However, I need help how this can be done in SQL and how would the table look like. Below is what my schema looks like:</p>
  <p><a href="https://i.stack.imgur.com/g1dHC.png" rel="nofollow noreferrer">Sample Schema</a></p>
  <p>In the sales fact, I also included a column containing the aggregate sales for all the product included in the sale.</p>
  <p>Ps. Same case with the Products but with Official_Receipt_Id as a single sale can also have many Official_Receipt_Id.</p>
  <p>Help will be highly appreciated.</p>