List:General Discussion« Previous MessageNext Message »
From:Jay Blanchard Date:June 15 2010 6:49pm
Subject:RE: query help
View as plain text  
[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;
Thread
query helpRichard Reina15 Jun
  • RE: query helpGavin Towey15 Jun
  • RE: query helpJay Blanchard15 Jun
    • Re: query helpJoerg Bruehe16 Jun
  • Re: query helpRichard Reina16 Jun
    • RE: query helpMartin Gainty16 Jun