title: How to merge two tables with one to many relationship
body: <p>I have two tables to main orders and ordered products.</p>
  
  <pre><code>Table 1: ORDERS
  "CREATE TABLE IF NOT EXISTS ORDERS("
                         "id_order INTEGER PRIMARY KEY AUTOINCREMENT,
                         "o_date TEXT,"
                         "o_seller TEXT,"
                         "o_buyer TEXT,"
                         "o_shipping INTEGER,"
                         "d_amount INTEGER,"
                         "d_comm INTEGER,"
                         "d_netAmount INTEGER)"
  Table 2: ORDERED_PRODUCTS
  "CREATE TABLE IF NOT EXISTS dispatch_products("
                         "id_order INTEGER NOT NULL REFERENCES ORDERS(id_order),"
                         "product_name INTEGER,"
                         "quantity INTEGER,"
                         "rate INTEGER)"
  </code></pre>
  
  <p>I tried to join these two tables using following query:</p>
  
  <pre><code>SELECT *
  FROM ORDERS a
  INNER JOIN ORDERED_PRODUCTS b
  ON a.id_order = b.id_order
  WHERE a.buyer = 'abc'
  </code></pre>
  
  <p>The issue is with the entries with multiple products in table 2.
  The output I'm getting is like below:</p>
  
  <pre><code>order_ID date seller buyer Ship   amt  comm nAmt Prod  Qty Rate
  1             A      x       5    100  5    115  Scale 10  10
  2             B      abc     10   100  5    115  pen    5  10
  2             B      abc     10   100  5    115  paper 10   5
  3             C      xyz     10   100  5    220  book   5  20
  3             C      xyz     10   100  5    220  stapl 10  10
  
  expected output:
  order_ID date seller buyer Ship   amt  comm nAmt Prod  Qty Rate
  1             A      x       5    100  5    115  Scale 10  10
  2             B      abc     10   100  5    115  pen    5  10
                                                   Paper 10   5
  3             C      xyz     10   100  5    220  Book   5  20
                                                   Stapl 10  10
  </code></pre>