title: I want to connect and display two tables from sql database
body: <p>Hi i want to use inner join to connect these two tables but i'm not sure how.</p>
  <p>This is the php code for now.</p>
  <pre><code> $query = &quot;SELECT * FROM reservation ORDER BY reserve_id desc&quot;;  
   $result = mysqli_query($connect, $query); 
  </code></pre>
  <p>and I want to connect these two tables by using inner join so I can see who chose which table in the reservation and I don't want other people to make a reservation on the same time and same tables as others.</p>
  <p><img src="https://i.stack.imgur.com/O5dn1.png" alt="Here you can see reservations" /></p>
  <p><img src="https://i.stack.imgur.com/o0LeB.png" alt="here you can see the tables" /></p>