Required to join 2 tables with their FKs in a 3rd table

by

The Tree table is the connection between the Forest table and the Species table. Think of it as two steps:

1) Starting from the Forest table, join to the Tree table (from Forest.Fo_name to Tree.Tr_forest)

2) Now that the Tree is known, join to the Species table (from Tree.species to Species.sp_name)

I’d write the final query like this:

SELECT Forest.Fo_name, Species.Sp_name, Species.Sp_woodtype
FROM Forest
JOIN Tree ON Forest.Fo_name=Tree.Tr_forest
JOIN Species ON Tree.species=Species.sp_name
WHERE Fo_loc="ARTIC"
ORDER BY Fo_name, Sp_name

More Related Contents:

  1. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  2. 1052: Column ‘id’ in field list is ambiguous
  3. Join tables with SUM issue in MYSQL
  4. MySQL Cannot Add Foreign Key Constraint
  5. Join between tables in two different databases?
  6. How can I join multiple SQL tables using the IDs?
  7. Why does MySQL report a syntax error on FULL OUTER JOIN?
  8. Mixing ANSI 1992 JOINs and COMMAs in a query
  9. Can a foreign key reference a non-unique index?
  10. MySQL – Conditional Foreign Key Constraints
  11. How do I use on delete cascade in mysql?
  12. Cumulative sum over a set of rows in mysql
  13. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  14. How to create relationships in MySQL
  15. MySQL JOIN the most recent row only?
  16. How to find non-existing data from another Table by JOIN?
  17. Is it possible to reference one column as multiple foreign keys?
  18. MySQL Inner Join Query Multiple Tables
  19. Difference between these two joining table approaches?
  20. Laravel join with 3 Tables
  21. MySQL LEFT JOIN 3 tables
  22. Foreign key constraints: When to use ON UPDATE and ON DELETE
  23. how to use a like with a join in sql?
  24. When to use a left outer join?
  25. In what order are MySQL JOINs evaluated?
  26. How to store a one to many relation in MySQL database?
  27. MySQL Multiple Joins in one query?
  28. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  29. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  30. How to get a list of months between two dates in mysql

Leave a Comment