OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
RE: query help

From: Jay Blanchard (jblanchardpocket.com)
Date: Tue Jun 15 2010 - 13:49:58 CDT

[snip]
I have a table similar to this:

 -------------------------
|transactions |
|ID |DATE |EMPLOYEE|
|234 |2010-01-05| 345 |
|328 |2010-04-05| 344 |
|239 |2010-01-10| 344 |

Is there a way to query such a table to give the days of the year that
employee 344 did not have a transaction?
[/snip]

SELECT DATE
FROM transactions
WHERE EMPLOYEE != '344'
GROUP BY DATE;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql