Re: tricky SQL SELECT

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 31 Jan 2003 16:31:42 -0000
Message-ID: <3e3aa4f6$0$240$ed9e5944@reading.news.pipex.net>

"Angel Cat" <kittycatangel_at_hotmail.com> wrote in message news:9b08c59d.0301310641.38be6566_at_posting.google.com...
> 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!

If this really is a commercial product and not a student project, then yes there is something you can do. you can explain that you cannot retrieve the data you want from the database that the tool has created.

I also don't see how you could ever insert or delete from this mess when data changed.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Fri Jan 31 2003 - 10:31:42 CST

Re: tricky SQL SELECT - help!