MySQL “NOT IN” query

by

To use IN, you must have a set, use this syntax instead:

SELECT * FROM Table1 WHERE Table1.principal NOT IN (SELECT principal FROM table2)

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. MySQL query finding values in a comma separated string
  3. Generating a range of numbers in MySQL
  4. How to get next/previous record in MySQL?
  5. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  6. How do I make a row generator in MySQL?
  7. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  8. How can I merge two MySQL tables?
  9. Can table columns with a Foreign Key be NULL?
  10. SQL: Find the max record per group [duplicate]
  11. Mysql recursion?
  12. is there a group_concat function in ms-access?
  13. Is there an alternative to TOP in MySQL?
  14. How many rows in a database are TOO MANY?
  15. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  16. Is it possible to have an indexed view in MySQL?
  17. mysql – how many columns is too many?
  18. Best database field type for a URL
  19. MySQL: How to copy rows, but change a few fields?
  20. How to renumber primary index
  21. Query that ignore the spaces
  22. mysql automatically store record creation timestamp
  23. Use A Union Or A Join – What Is Faster [closed]
  24. MySQL – how to front pad zip code with “0”?
  25. Find the number of columns in a table
  26. Mysql, reshape data from long / tall to wide
  27. MySQL: Compare differences between two tables
  28. Mysql strip time component from datetime
  29. How do I start auto increment from a specific point?
  30. How do MySQL views work?

Leave a Comment