At 12:44 2013-10-08, Ted Roche <[email protected]> wrote:
On Tue, Oct 8, 2013 at 3:25 PM, Dan Covill <[email protected]> wrote:
> The simplest way I can think of to do that is to have a separate 1-field
> table of valid WFC's. Do your count(WFC) query, then match it to the
> ValidWFC table and report the zeroes as well as your counts.
> Assuming WFC's get validated, you may be able to piggy-back on whatever
> the validation mechanism is using.
I ASSuMEd (and you know what happens then!) that the WFCs were the
funccodes and that they were all present in the Work Function Table (cwkf)
but not all were present in the invoices table (catx) and Gene was seeking
the list of funccodes that hadn't been invoiced.
If I've got that wrong, Gene, let me know.
No, I was after a list of certain WFCs and how many times each
was used in catx (whether 0 or more times).
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
