Finding unmatched records with SQL

by 
SELECT
    *
FROM
    Table2 T2
WHERE
    NOT EXISTS (SELECT *
        FROM
           Table1 T1
        WHERE
           T1.State = T2.State AND
           T1.Product = T2.Product AND
           T1.Distributor="X")

This should be ANSI compliant.

More Related Contents:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. SQL join: selecting the last records in a one-to-many relationship
  3. SQL/mysql – Select distinct/UNIQUE but return all columns?
  4. COUNT(*) vs. COUNT(1) vs. COUNT(pk): which is better? [duplicate]
  5. SQL SELECT WHERE field contains words
  6. JOIN two SELECT statement results
  7. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  8. What is the difference between using a cross join and putting a comma between the two tables?
  9. How to get a list of column names on Sqlite3 database?
  10. How to delete from select in MySQL?
  11. SQL WHERE ID IN (id1, id2, …, idn)
  12. Are there any way to execute a query inside the string value (like eval) in PostgreSQL?
  13. Select TOP X (or bottom) percent for numeric values in MySQL
  14. Fastest way to determine if record exists
  15. How to kill a running SELECT statement
  16. How do I select all the columns from a table, plus additional columns like ROWNUM?
  17. DATEDIFF function in Oracle [duplicate]
  18. Best way to do nested case statement logic in SQL Server
  19. How to select multiple rows filled with constants?
  20. How to select only the first rows for each unique value of a column?
  21. Why postgres returns unordered data in select query, after updation of row?
  22. SQL column reference “id” is ambiguous
  23. How to select records without duplicate on just one field in SQL?
  24. how does SELECT TOP works when no order by is specified?
  25. SQL: Two select statements in one query
  26. Check if two “select”s are equivalent
  27. SQL: Select rows with a column value that occurs at least N times?
  28. “SELECT *” vs “SELECT ” for performance
  29. Combine Two Tables in Select (SQL Server 2008)
  30. Select rows where column value has changed

Leave a Comment