SQL

SQL INNER JOIN With Three Tables

SELECT C.customer_id, C.first_name, O.amount, S.status
FROM Customers AS C
INNER JOIN Orders AS O
ON C.customer_id = O.customer
INNER JOIN Shipping AS S
ON C.customer_id = S.customer_id;

Three inner joins SQL

-- Using INNER JOING to join multiple tables
SELECT c.code, name, region, e.year, fertility_rate, unemployment_rate -- Select fields
  FROM countries AS c -- From countries (alias as c)
  INNER JOIN populations AS p -- Join to populations (as p)
    ON c.code = p.country_code -- Match on country code
  INNER JOIN economies AS e -- Join to economies (as e)
    ON c.code = e.code AND p.year = e.year; -- Match on country code and year