MySQL LEFT JOIN 3 tables

by

You are trying to join Person_Fear.PersonID onto Person_Fear.FearID – This doesn’t really make sense. You probably want something like:

SELECT Persons.Name, Persons.SS, Fears.Fear FROM Persons
LEFT JOIN Person_Fear
    INNER JOIN Fears
    ON Person_Fear.FearID = Fears.FearID
ON Person_Fear.PersonID = Persons.PersonID

This joins Persons onto Fears via the intermediate table Person_Fear. Because the join between Persons and Person_Fear is a LEFT JOIN, you will get all Persons records.

Alternatively:

SELECT Persons.Name, Persons.SS, Fears.Fear FROM Persons
LEFT JOIN Person_Fear ON Person_Fear.PersonID = Persons.PersonID
LEFT JOIN Fears ON Person_Fear.FearID = Fears.FearID

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. Join between tables in two different databases?
  5. Required to join 2 tables with their FKs in a 3rd table
  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. Cumulative sum over a set of rows in mysql
  10. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  11. MySQL JOIN the most recent row only?
  12. How to find non-existing data from another Table by JOIN?
  13. MySQL Inner Join Query Multiple Tables
  14. Difference between these two joining table approaches?
  15. Laravel join with 3 Tables
  16. how to use a like with a join in sql?
  17. When to use a left outer join?
  18. In what order are MySQL JOINs evaluated?
  19. How to store a one to many relation in MySQL database?
  20. MySQL Multiple Joins in one query?
  21. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  22. How to split the name string in mysql?
  23. JOIN queries vs multiple queries
  24. How to set a maximum execution time for a mysql query?
  25. How to copy a row and insert in same table with a autoincrement field in MySQL?
  26. Can MySQL convert a stored UTC time to local timezone?
  27. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  28. Does Order of Fields of Multi-Column Index in MySQL Matter
  29. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  30. Postgres LEFT JOIN with WHERE condition

Leave a Comment