title: How do I structure a Database with a Sales Table MySql
body: <p>I have a sales table that I want to record all the sales done by the employee.
  The problem i'm having is that I can only store one ProductId that comes from a Products table. What is wrong is that a sale has multiples products and with my current structure I can only store one ProductId. I know my approach is wrong but I just don't know how to properly fix it. The question I have is how do I store multiples products in the Sales Table.</p>
  
  <p>This is my Sales Table columns.</p>
  
  <pre><code>CREATE TABLE `Sales` (
  `SaleId` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `EmployeeId` int(11) unsigned NOT NULL,
  `ProductId` int(11) unsigned NOT NULL,
  PRIMARY KEY (`SaleId`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>