|
Yesterday, I wrote:
Would anybody know of a way to key a join on fields in two separate based-on physicals?
A bit more detail about the specific situation: (I'd say more, but then I'd have to kill all of you :-P)Our Wintouch product currently has a search-by-name function for both accounts and contacts, which works through a logical file keyed on "scrubbed" versions of those fields. We are introducing a feature to narrow the results of those searches to a specific ZIP code. Unfortunately, one has to cross two join boundaries to get to the ZIP code.
Naturally, once my SQL project is up and running, and has replaced its OPNQRYF-based predecessor, and once I've put some of what I learned last week in Rochester to use, we can go through that, the same as we would for an arbitrary query, but I worry somewhat about the performance (particularly since the performance of the OPNQRYF version is not exactly stellar).
-- JHHL
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
