List:General Discussion« Previous MessageNext Message »
From:Richard Reina Date:June 15 2010 6:30pm
Subject:query help
View as plain text  
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?

Thanks for the help.

Richard 
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