| 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 help | Richard Reina | 15 Jun |
| • RE: query help | Gavin Towey | 15 Jun |
| • RE: query help | Jay Blanchard | 15 Jun |
| • Re: query help | Joerg Bruehe | 16 Jun |
| • Re: query help | Richard Reina | 16 Jun |
| • RE: query help | Martin Gainty | 16 Jun |
