title: Java spring jdbc: Jdbctemplate join query
body: <p>I want to retrieve a list of Order objects.
  Each Order object may have a list of OrderRows. OrderRows are kept in a separate table. How do I use the query below with Jdbctemplate?</p>
  
  <pre><code>"SELECT order_number, itemname, quantity, price FROM orders" +
  " LEFT JOIN order_rows ON orders.id = order_rows.order_id" +
  " WHERE orders.id = ?"
  </code></pre>