How to find missing attendance from the database table

by

I have found the correct answer of my question.

I created a month_days table where i inserted all days of 12 months. 

id date
1  2017-04-1
2  2017-04-2
3  2017-04-3
.
.
30 2017-04-30
31  2017-05-1
32  2017-05-2
33  2017-05-3
.
.
34 2017-05-31

This is the query

SELECT *
FROM month_days d
CROSS JOIN employees e
LEFT JOIN attendances l ON d.date = DATE( l.log_date ) AND 
e.emp_code = l.emp_code
WHERE l.emp_code IS NULL
GROUP BY d.date, e.emp_code

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. How Secure Is This Login System? (Using Cookies In PHP)
  3. Organization db for blog posts with Mysql and Php [closed]
  4. mysqli or PDO – what are the pros and cons? [closed]
  5. Commands out of sync; you can’t run this command now
  6. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  7. Get table column names in MySQL?
  8. PHP code to convert a MySQL query to CSV [closed]
  9. How to resolve ambiguous column names when retrieving results?
  10. Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
  11. Use bound parameter multiple times
  12. The holy grail of cleaning input and output in php?
  13. MySQL: Select Random Entry, but Weight Towards Certain Entries
  14. Multiple mysql INSERT statements in one query php [duplicate]
  15. how safe are PDO prepared statements
  16. How to join three table by laravel eloquent model
  17. Secure files for download
  18. How to connect to MySQL database in PHP using mysqli extension?
  19. MySQL – Access denied for user [duplicate]
  20. Calling stored procedure with Out parameter using PDO
  21. When *not* to use prepared statements?
  22. org.json.JSONException: Value
  23. PHP Check for NULL
  24. How to display an BLOB image stored in MySql database?
  25. How to bind LIKE values using the PDO extension?
  26. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  27. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  28. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  29. PHP 7 RC3: How to install missing MySQL PDO
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment