Re: Dealing with complex queries

On Tue, 4 Feb 2003, Bruno Wolff III wrote:

> On Mon, Feb 03, 2003 at 16:32:10 -0500,
>   Francisco Reyes <lists@natserv.com> wrote:
> > Any hints suggestions on dealing with complex queries.
>
> >         substring(ppl.carried_as from 1 for 3)
> >                 = substring(jc.last from 1 for 3) and
>
> Joining on substrings is a good sign that your design needs rethinking.

The tables in the substring comparison are some of our tables compared
to tables supplied by another company. It is a fact that the names don't
always match and have variations.

The whole excersise is to match by names to then populate our table with
their keys so in the future we can match by keys in feeds we receive from
them.