Count with out using a joins

by

The logic in your query is way off. You are using the having clause to compare ClientID with a count… how do you expect that to work?

What you do want to do is to skip the group by and having clauses and use the in operator instead in a condition like:

where ClientID not in (select ClientID from job)

More Related Contents:

  1. Case statement for multiple columns
  2. Transaction lock in sql
  3. SQLite – UPSERT *not* INSERT or REPLACE
  4. Best way to do multi-row insert in Oracle?
  5. Why does Oracle 9i treat an empty string as NULL?
  6. Unioning two tables with different number of columns
  7. How do I use variables in Oracle SQL Developer?
  8. Formatting Numbers by padding with leading zeros in SQL Server
  9. FULL OUTER JOIN with SQLite
  10. How to include “zero” / “0” results in COUNT aggregate?
  11. Importance of varchar length in MySQL table
  12. SQL SELECT speed int vs varchar
  13. How do I query for all dates greater than a certain date in SQL Server?
  14. Define variable to use with IN operator (T-SQL)
  15. Drop all tables command
  16. Sql script to find invalid email addresses
  17. ORA 00904 Error:Invalid Identifier
  18. What does the colon sign “:” do in a SQL query?
  19. Syntax of for-loop in SQL Server
  20. Why does ISNUMERIC(‘.’) return 1?
  21. Unfindable SQLite Syntax Error
  22. Comparison of Relational Databases and Graph Databases
  23. Inserting into Oracle and retrieving the generated sequence ID
  24. The difference between ‘AND’ and ‘&&’ in SQL
  25. Converting String List into Int List in SQL
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. How in H2DB get sql dump like in MySql?
  28. SQL Server equivalent to MySQL’s EXPLAIN
  29. SQL: Using DATEADD with bigints
  30. Concat all column values in sql

Leave a Comment