title: Joining two indirectly related tables without including columns from tables in between
body: <p>Based on the following ERD, I'm trying to write a query that displays reservations made directly by customers and include reservation id, reservation date, customer id, customer first name, tour trip id, tour category name, tour trip date</p>
  
  <p><a href="https://i.stack.imgur.com/P7hKU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/P7hKU.jpg" alt="enter image description here"></a></p>
  
  <p>I've been able to include everything in my query except for the tour category name because the TOUR_SITES table is in the way. Is there a way I can join the category name from the TOUR_PACKAGE table without adding any extra columns?</p>
  
  <pre><code>  SELECT  r.RESERVATION_ID, r.RESERVATION_DATE, 
  c.CUSTOMER_ID, c.FIRST_NAME,t.TRIP_ID, o.TRIP_DATE/*, P.CATEGORY_NAME*/
  
  FROM CUSTOMER c 
  INNER JOIN RESERVATION r
  ON
  r.CUSTOMER_ID=c.CUSTOMER_ID
  
  INNER JOIN TOURTRIP_RESERVATION t
  ON
  r.RESERVATION_ID=t.RESERVATION_ID
  
  INNER JOIN TOUR_TRIP O
  ON
  t.TRIP_ID=o.TRIP_ID
  
  
  WHERE AGENT_ID IS NULL;
  </code></pre>