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. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/cacw6n4ssdnzydtrpfur3dqp-4aeei0f4n2j6htobua6dzhu...@mail.gmail.com ** 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.
