SELECT * WHERE NOT EXISTS

by

You didn’t join the table in your query.

Your original query will always return nothing unless there are no records at all in eotm_dyn, in which case it will return everything.

Assuming these tables should be joined on employeeID, use the following: 

SELECT  *
FROM    employees e
WHERE   NOT EXISTS
        (
        SELECT  null 
        FROM    eotm_dyn d
        WHERE   d.employeeID = e.id
        )

You can join these tables with a LEFT JOIN keyword and filter out the NULL‘s, but this will likely be less efficient than using NOT EXISTS.

More Related Contents:

  1. MySQL monthly Sale of last 12 months including months with no Sale
  2. Mysql select where not in table
  3. MySQL Join Where Not Exists
  4. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  5. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  6. Count the occurrences of DISTINCT values
  7. Column count doesn’t match value count at row 1
  8. How to search JSON data in MySQL?
  9. MySQL > Table doesn’t exist. But it does (or it should)
  10. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  11. How do I modify a MySQL column to allow NULL?
  12. Connect to mysql in a docker container from the host
  13. Change decimal separator in MySQL
  14. Docker-compose check if mysql connection is ready
  15. SQL: selecting rows where column value changed from previous row
  16. MySQL WHERE IN ()
  17. How to skip certain database tables with mysqldump?
  18. Using MySql with Entity Framework 4 and the Code-First Development CTP
  19. MySQL treats ÅÄÖ as AAO?
  20. How can write queries in MySQL that can parse JSON data in a column?
  21. MySQL Time Zones
  22. How to use django models with foreign keys in different DBs?
  23. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  24. Continue SQL query even on errors in MySQL workbench
  25. Which DATATYPE is better to use TEXT or VARCHAR?
  26. How to generate a UUIDv4 in MySQL?
  27. Select by Month of a field
  28. MySQL Illegal mix of collations
  29. delete rows from multiple tables
  30. MySQL Multiple Joins in one query?

Leave a Comment