How to find non-existing data from another Table by JOIN?

by

An INNER JOIN doesn’t help here.

One way to solve this is by using a LEFT JOIN:

SELECT w.* 
FROM TABLE1 W 
LEFT JOIN TABLE2 V ON W.name = V.name
WHERE ISNULL(V.name);

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. MySQL Inner Join Query Multiple Tables
  13. Difference between these two joining table approaches?
  14. Laravel join with 3 Tables
  15. MySQL LEFT JOIN 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. SQL Print the name of all Employees together with the name of their supervisor
  22. MySQL offset infinite rows
  23. Can a foreign key reference a non-unique index?
  24. Get the latest date from grouped MySQL data
  25. MySQL update a joined table
  26. MySQL Error 1264: out of range value for column
  27. Split a string and loop through values in MySQL stored procedure
  28. MySQL Select Query – Get only first 10 characters of a value
  29. Most efficient way to store IP Address in MySQL [duplicate]
  30. mysql select id and name from other table and join query

Leave a Comment