[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 To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
