[thelist] substring and a join?

[Lauri Vain]

Hi rudy,

> at first glance this looks okay -- assuming you take it out of the FROM
> clause and put it into the SELECT list   ;o)

Yeah, tried that first but some source told that I needed to put it into the
FROM list. Didn't work either way at first but got it working now.

The query looks like this now: