title: how to create join between two ordered table and save the order
body: <p>I need to join between 2 tables , every table is ordered and I need to save this order , but to return only one table.
  let say that I have table order from a to z
  and second table order a to z
  and I want to create
  single table ordered like that:</p>
  
  <p><a href="https://i.stack.imgur.com/3A6ri.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3A6ri.png" alt="enter image description here"></a></p>
  
  <p>how can I do that?
  AM I need to create temporare table?</p>