How to do an INNER JOIN on multiple columns

by

You can JOIN with the same table more than once by giving the joined tables an alias, as in the following example:

SELECT 
    airline, flt_no, fairport, tairport, depart, arrive, fare
FROM 
    flights
INNER JOIN 
    airports from_port ON (from_port.code = flights.fairport)
INNER JOIN
    airports to_port ON (to_port.code = flights.tairport)
WHERE 
    from_port.code="?" OR to_port.code="?" OR airports.city='?'

Note that the to_port and from_port are aliases for the first and second copies of the airports table.

More Related Contents:

  1. What’s the best practice for primary keys in tables? [closed]
  2. What are best practices for multi-language database design? [closed]
  3. What is atomicity in dbms
  4. SQLite – How do you join tables from different databases?
  5. MySQL dump by query
  6. SQL ROWNUM how to return rows between a specific range
  7. SQLite – ORDER BY RAND()
  8. How would you implement sequences in Microsoft SQL Server?
  9. SQL how to compare two tables for same data content?
  10. What does =* mean?
  11. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  12. MySQL equivalent of DECODE function in Oracle
  13. What datatype to use when storing latitude and longitude data in SQL databases? [duplicate]
  14. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  15. Favourite performance tuning tricks [closed]
  16. How do I alter the position of a column in a PostgreSQL database table?
  17. Is it necessary to create tables each time you connect the derby database?
  18. Venn Diagram for Natural Join
  19. Database efficiency – table per user vs. table of users
  20. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  21. Find rows that have the same value on a column in MySQL
  22. SQL: Using NULL values vs. default values
  23. Using SQL Server as a DB queue with multiple clients
  24. SQL 2005 – The column was specified multiple times
  25. Upsert with a transaction
  26. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  27. Relational Data Model for Double-Entry Accounting
  28. Creating a custom ODBC driver
  29. Do conditional INSERT with SQL?
  30. ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?

Leave a Comment