Mysql select where not in table

I think your last statement is the best way. You can also try

SELECT A.*    
from A left join B on 
    A.x = B.y
    where B.y is null

Related Contents:

  1. MySQL Join Where Not Exists
  2. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  3. How can I do three table JOINs in an UPDATE query?
  4. 1052: Column ‘id’ in field list is ambiguous
  5. Join tables with SUM issue in MYSQL
  6. MySQL: Quick breakdown of the types of joins [duplicate]
  7. Join between tables in two different databases?
  8. MySQL update table based on another tables value
  9. MySQL JOIN ON vs USING?
  10. Required to join 2 tables with their FKs in a 3rd table
  11. MySQL join with where clause
  12. How can I join multiple SQL tables using the IDs?
  13. a count for each join – optimisation
  14. JOIN queries vs multiple queries
  15. Why does MySQL report a syntax error on FULL OUTER JOIN?
  16. conditional join in mysql
  17. MYSQL Select MAX Date inside a join statement
  18. CROSS/OUTER APPLY in MySQL
  19. Mixing ANSI 1992 JOINs and COMMAs in a query
  20. Combine Multiple child rows into one row MYSQL
  21. Cumulative sum over a set of rows in mysql
  22. SELECT * WHERE NOT EXISTS
  23. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  24. MySql Count cannot show 0 values
  25. mySQL – Create a New Table Using Data and Columns from Three Tables
  26. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  27. MySQL JOIN the most recent row only?
  28. Count with IF condition in MySQL query
  29. How to use mysql JOIN without ON condition?
  30. mysql query show multiple tables from one ID column
  31. When to use STRAIGHT_JOIN with MySQL
  32. MySQL update a joined table
  33. How to join two tables using a comma-separated-list in the join field
  34. MySQL LEFT JOIN 3 tables
  35. MySQL join query using like?
  36. MySQL monthly Sale of last 12 months including months with no Sale
  37. How to find non-existing data from another Table by JOIN?
  38. LEFT JOIN only first row
  39. MySQL JOIN with LIMIT 1 on joined table
  40. Can I resolve this with pure mysql? (joining on ‘;’ separated values in a column)
  41. MySQL Inner Join Query Multiple Tables
  42. What is the default MySQL JOIN behaviour, INNER or OUTER?
  43. joining the same table twice on different columns
  44. MySQL Insert & Joins
  45. MySQL Multiple Joins in one query?
  46. MySQL how to join tables on two fields
  47. Error related to only_full_group_by when executing a query in MySql
  48. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  49. Search for all occurrences of a string in a mysql database [duplicate]
  50. Setting column values as column names in the SQL query result

Leave a Comment