Re: tricky SQL SELECT - help!

Angel Cat wrote:

> Hi all!
>
> Please, I need SQL help not new db design!
>
> This schema is created by a 3rd party tool that I have NO CONTROL
> over. 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!
>
> Please help!

Actually you don't.

You need a new schema or to start revising your resume'. Because no SQL statement is going to deal with this garbage.

If you seriously have no choice .... then you either write a stored procedure or throw the tool away.

I'd choose the later.

Daniel Morgan Received on Fri Jan 31 2003 - 11:13:30 CST