title: How to join every row from table A to every two rows from table B
body: <p>How to join every row from table A to every two rows from table B</p>
  <p>I have two table
  Table A</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>league_name</th>
  <th>league_id</th>
  <th>match</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>date1</td>
  <td>name1</td>
  <td>1032</td>
  <td>team1 vs team2</td>
  </tr>
  <tr>
  <td>date2</td>
  <td>name2</td>
  <td>1033</td>
  <td>team3 vs team4</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table B</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>team_name</th>
  <th>goal_for</th>
  <th>goal_against</th>
  <th>team_id</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>team1</td>
  <td>5</td>
  <td>4</td>
  <td>1</td>
  <td>1</td>
  </tr>
  <tr>
  <td>team2</td>
  <td>7</td>
  <td>3</td>
  <td>2</td>
  <td>2</td>
  </tr>
  <tr>
  <td>team3</td>
  <td>5</td>
  <td>4</td>
  <td>3</td>
  <td>1</td>
  </tr>
  <tr>
  <td>team4</td>
  <td>7</td>
  <td>3</td>
  <td>4</td>
  <td>2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>To get Result like this</p>
  <p>two rows after joining table A and table B</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>league_name</th>
  <th>league_id</th>
  <th>match</th>
  <th>team_name</th>
  <th>g_for</th>
  <th>g_against</th>
  <th>team_id</th>
  <th>status</th>
  <th>team_name</th>
  <th>goal_for</th>
  <th>goal_against</th>
  <th>team_id</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>date1</td>
  <td>name1</td>
  <td>1032</td>
  <td>team1 vs team2</td>
  <td>team1</td>
  <td>5</td>
  <td>4</td>
  <td>1</td>
  <td>1</td>
  <td>team2</td>
  <td>7</td>
  <td>3</td>
  <td>2</td>
  <td>2</td>
  </tr>
  <tr>
  <td>date2</td>
  <td>name2</td>
  <td>1033</td>
  <td>team3 vs team4</td>
  <td>team3</td>
  <td>5</td>
  <td>4</td>
  <td>3</td>
  <td>1</td>
  <td>team4</td>
  <td>7</td>
  <td>3</td>
  <td>4</td>
  <td>2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>note the status column the home team status is 1 and away team column is 2 so i wish to have the the two rows together join a row on the table A</p>