Re: Keying across a join

["James H H Lampert" <jamesl@xxxxxxxxxxx>]

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