[thelist] SQL View: Join? SubQuery?

[Joshua Olson]

----- Original Message -----
From: "rudy" <r937 at interlog.com>
To: <thelist at lists.evolt.org>
Subject: Re: [thelist] SQL View: Join? SubQuery?


> since the comma-separated list is a string, try
>
>    on Table2.names like '%' || Table1.id || '%'
>
> in Susan's case,
>
>    on PerformedPieces like '%' || CompID  || '%'

I can see how this could get really nasty if PerformedPieces was
'14,15,16,17'.  The query would conceivably match CompID = 1, 4, 5, 6, and
7.  While not what you intended, I'm sure, it does illustrate that this sort
of join is fairly impractical.

Susan, I'd concur that another data structure would be your best bet in the
long (and short) run.

-joshua