How to join multiple columns from different tables How can you join multiple tables and display values from tables that referenced further in other tables?

select booking.booking_id,
(select customer.first_name from customer
where customer.customer_id=booking.customer_id) as First_Name,
(select customer.last_name from customer
where customer.customer_id=booking.customer_id) as Last_Name,
(select aircraft_model.aircraft_model from aircraft_model
where aircraft_model_id = (select aircraft.aircraft_model_id from 
aircraft
where aircraft_modle_id = booking.aircraft_id))

from booking;


As you can see I'm trying to pass on the value of aircraft_model_id from the table booking to the aircraft_model table. 

The only table connecting the aircraft_model table to the booking table is the aircraft table.. 

I'm completely new to sql so please do state if there are any errors.

Added in the codes for the table: 

CREATE TABLE Booking (
Booking_ID            NUMBER(10)   NOT NULL PRIMARY KEY,
Company_ID            NUMBER(10)   NOT NULL REFERENCES 
Penrhyn_Jet_Charter(Company_ID),
Customer_ID           NUMBER(10)   NOT NULL REFERENCES 
Customer(Customer_ID),
Aircraft_ID           NUMBER(10)   NOT NULL REFERENCES 
Aircraft(Aircraft_ID),
Assignment_No         NUMBER(10)   NOT NULL,
Booking_Date          DATE         DEFAULT SYSDATE,
Charter_Cost          NUMBER(14,2) CHECK(Charter_Cost &gt; 0),
Departure_Date        DATE         NOT NULL,
Departure_Location    CHAR(3)      NOT NULL,
Arrival_Date          DATE         NOT NULL,
Arrival_Destination   CHAR(3)      NOT NULL
);

CREATE TABLE Aircraft_Model (
Aircraft_Model_ID     NUMBER(10)    NOT NULL PRIMARY KEY,
Aircraft_Model        VARCHAR2(255) NOT NULL,
No_Of_Aircrafts       NUMBER(10)    NOT NULL CHECK (No_Of_Aircrafts &gt; 
0),
Aircraft_Description  VARCHAR2(500) 
);

CREATE TABLE Aircraft (
Aircraft_ID       NUMBER(10) NOT NULL PRIMARY KEY,
Company_ID        NUMBER(10) NOT NULL REFERENCES 
Penrhyn_jet_Charter(Company_ID),
Aircraft_Model_ID NUMBER(10) NOT NULL REFERENCES 
Aircraft_Model(Aircraft_Model_ID),
Seats             NUMBER(10) NOT NULL
);
Try this one, use INNER JOIN from booking to aircraft_model

SELECT
    b.booking_id,
    c.firstname AS First_Name,
    c.last_name AS Last_Name,
    am.aircraft_model
FROM booking b
INNER JOIN customer c ON b.customer_id = c.customer_id
INNER JOIN aircraft a ON b.aircraft_id = a.aircraft_model_id
INNER JOIN aircraft_model am ON a.aircraft_model_id = am.aircraft_model_id