title: Query for Joining two tables to get result from 2nd table in reference
body: <p>I have two tables Order and Transaction</p>
  <p><strong>Order</strong> Table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>OrderId</th>
  <th>TransId</th>
  <th>OrderDate</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>54</td>
  <td>11551</td>
  <td>01-12-2021</td>
  </tr>
  <tr>
  <td>2</td>
  <td>55</td>
  <td>11552</td>
  <td>02-12-2021</td>
  </tr>
  <tr>
  <td>3</td>
  <td>56</td>
  <td>11553</td>
  <td>02-12-2021</td>
  </tr>
  <tr>
  <td>4</td>
  <td>57</td>
  <td>11554</td>
  <td>05-12-2021</td>
  </tr>
  <tr>
  <td>5</td>
  <td>58</td>
  <td>11555</td>
  <td>08-12-2021</td>
  </tr>
  <tr>
  <td>6</td>
  <td>59</td>
  <td>11556</td>
  <td>09-12-2021</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>Transaction</strong> Table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>TransId</th>
  <th>OrderId</th>
  <th>PaymentMethod</th>
  <th>Amount</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>11551-1</td>
  <td>54</td>
  <td>Cash</td>
  <td>1000</td>
  </tr>
  <tr>
  <td>2</td>
  <td>11552-1</td>
  <td>55</td>
  <td>Cash</td>
  <td>500</td>
  </tr>
  <tr>
  <td>3</td>
  <td>11552-2</td>
  <td>55</td>
  <td>Card</td>
  <td>200</td>
  </tr>
  <tr>
  <td>4</td>
  <td>11553-1</td>
  <td>56</td>
  <td>Cash</td>
  <td>500</td>
  </tr>
  <tr>
  <td>5</td>
  <td>11553-2</td>
  <td>56</td>
  <td>Card</td>
  <td>200</td>
  </tr>
  <tr>
  <td>6</td>
  <td>11553-3</td>
  <td>56</td>
  <td>UPI</td>
  <td>100</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Here we have 3 Transaction methods Cash, Card and UPI.</p>
  <p>I want to get total <em>Amount</em> collected using <strong>Cash</strong> as <em>PaymentMethod</em> done for  period  01-12-2021 to 08-12-2021 in orderDate of Order Table</p>