Re: tricky SQL SELECT - help!

kittycatangel_at_hotmail.com (Angel Cat) wrote:
> Hi all!
>
> Please, I need SQL help not new db design!

No, you need a new db design.

> This schema is created by a 3rd party tool that I have NO CONTROL
> over.

You say tool, not application. Of course you have control over a "tool". Don't use it! design your own tables. (BTW, I think a tool is something that makes your work *easier*. That being the case, the software you refer to is not a tool. Or maybe you're using it wrong.)

> I know the schema sucks but when you work with a tool that
> creates the schema for you, there's nothing you can do about it!

Stop using the tool.

> Please help!

This will be a Pyrrhic bit of help, but affix '%;' and ';%' to each end of the id, like '%;'||(select statement here)||';%'

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service              New Rate! $9.95/Month 50GB