Why do I get an error from this sub query script?

by

This is what your actual query is 

 SELECT effectiveDate,
 CASE
        WHEN note="REGULAR LOGGED" THEN log
      END
     FROM schedules LEFT JOIN timesheet ON schedules.effectiveDate = timesheet.date WHERE schedules.empid='40'
    AND YEAR(effectiveDate) = YEAR(CURDATE()) AND MONTH(effectiveDate) ='1' GROUP BY effectiveDate.

Not sure why you’re using a subquery

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL: Return 2 different result together
  3. Get top n records for each group of grouped results
  4. need to return two sets of data with two different where clauses
  5. quick selection of a random row from a large table in mysql
  6. Join tables with SUM issue in MYSQL
  7. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  8. Return default result for IN value regardless
  9. How can I search (case-insensitive) in a column using LIKE wildcard?
  10. sql joins as venn diagram
  11. How can I join multiple SQL tables using the IDs?
  12. MySQL, better to insert NULL or empty string?
  13. SQL: Repeat a result row multiple times, and number the rows
  14. SQL: selecting rows where column value changed from previous row
  15. Why do results from a SQL query not come back in the order I expect?
  16. How to generate data in MySQL?
  17. MySQL combine two columns and add into a new column
  18. Invalid default value for ‘dateAdded’
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. How to set a MySQL row to READ-ONLY?
  21. How to create dummy variable columns for thousands of categories in Google BigQuery?
  22. Mysql: Order by like?
  23. Most efficient way to store IP Address in MySQL [duplicate]
  24. Getting first day of the week in MySql using Week No
  25. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  26. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. MySQL update statement to store ranking positions
  29. How to convert a varchar column type to date type without losing the dates
  30. MySQL Multiple Joins in one query?

Leave a Comment