MySQL Join Where Not Exists

by

I’d probably use a LEFT JOIN, which will return rows even if there’s no match, and then you can select only the rows with no match by checking for NULLs.

So, something like:

SELECT V.*
FROM voter V LEFT JOIN elimination E ON V.id = E.voter_id
WHERE E.voter_id IS NULL

Whether that’s more or less efficient than using a subquery depends on optimization, indexes, whether its possible to have more than one elimination per voter, etc.

More Related Contents:

  1. Mysql select where not in table
  2. How can I select data from different tables?
  3. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  4. How can I do three table JOINs in an UPDATE query?
  5. MySQL: Quick breakdown of the types of joins [duplicate]
  6. Join between tables in two different databases?
  7. MySQL update table based on another tables value
  8. MySQL JOIN ON vs USING?
  9. Required to join 2 tables with their FKs in a 3rd table
  10. MySQL join with where clause
  11. JOIN queries vs multiple queries
  12. Why does MySQL report a syntax error on FULL OUTER JOIN?
  13. CROSS/OUTER APPLY in MySQL
  14. Mixing ANSI 1992 JOINs and COMMAs in a query
  15. a count for each join – optimisation
  16. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  17. MySql Count cannot show 0 values
  18. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  19. MySQL JOIN the most recent row only?
  20. MySQL update a joined table
  21. MySQL JOIN with LIMIT 1 on joined table
  22. MySQL Inner Join Query Multiple Tables
  23. Difference between these two joining table approaches?
  24. Laravel join with 3 Tables
  25. MySQL Insert & Joins
  26. How to join two tables using a comma-separated-list in the join field
  27. MySQL LEFT JOIN 3 tables
  28. When to use a left outer join?
  29. In what order are MySQL JOINs evaluated?
  30. How to store a one to many relation in MySQL database?

Leave a Comment