Access substitute for EXCEPT clause

by

In order to get rid of the EXCEPT you could combine the conditions and negate the second one:

SELECT DISTINCT 
       P.Name, 
       T.Training
  FROM Prof AS P, 
       Training_done AS TC, 
       Trainings AS T
 WHERE ((P.Name Like '*' & NameProf & '*') AND
        (P.Primary_Area = T.Cod_Area)) 
   AND NOT ((P.Name Like '*' & NameProf & '*') AND
            (P.Cod_Prof = TC.Cod_Prof));

More Related Contents:

  1. sql in ms-access [closed]
  2. Managing and debugging SQL queries in MS Access
  3. Upserting in MS-access
  4. How to get matching data from another SQL table for two different columns: Inner Join and/or Union?
  5. How to simulate UNPIVOT in Access?
  6. Table-less UNION query in MS Access (Jet/ACE)
  7. SQL Query – Using Order By in UNION
  8. Ms Access Query: Concatenating Rows through a query
  9. Date Difference between consecutive rows
  10. Using Excel VBA to export data to MS Access table
  11. Top n records per group sql in access
  12. Access-SQL: Inner Join with multiple tables
  13. Address standardization within a database
  14. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  15. Achieving ROW_NUMBER / PARTITION BY in MS Access
  16. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  17. SQL Updating from an inner join
  18. How to delete in MS Access when using JOIN’s?
  19. Lightweight SQL database which doesn’t require installation [closed]
  20. Convert String to Date in MS Access Query
  21. HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
  22. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  23. Editing Record issues in Access / SQL (Write Conflict)
  24. How do I create a table alias in MySQL
  25. How to save the result of a SQL query into a variable in VBA?
  26. Select query with date condition
  27. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  28. Microsoft Access – Case Query
  29. CONCAT equivalent in MS Access
  30. Check if access table exists

Leave a Comment