Re: SQL help, Please???

Being asked to do something and not being given the resources is a recipe for disaster.

But are you sure you don't have access to the SQL from which the views were constructed? I've no doubt a product like TOAD or OEM or SQL Navigator or DB Artisan or reverse engineering into ERwin or Designer would give it to you in a couple of seconds work.

And have you asked for it? Any decent DBA could give it to you in a few seconds too.

Daniel A. Morgan

"Lynn C. Ormond" wrote:

> Thanks for your reply, Daniel.
>
> Unfortunately, I don't have access to the SQL or rights to create anything.
> I only have access to the views.
> The first file is real estate listings, the second is room records ( 0 - 8 )
> of them for each record in the first file.
> I've also discovered a third file with a remarks field for the listings in
> the first file.
>
> Thanks for your help. You were defineately right about the speed problem.
> The connection timed out before
> I got a single record. Ain't life grand?
>
> --
>
> Lynn C. Ormond
> Lucero Research
> Reply to: Lynn_at_Lucero.com
> (520) 537-1300 x120
> Please include company name in message
>
> Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message
> news:3AE668FF.426F93AD_at_exesolutions.com...
> > "Lynn C. Ormond" wrote:
> >
> > > I have 2 Oracle 7 views I need to combine with a select statement.
> > >
> > > The first has 100,000 + records with a unique key. The second has
 multiple
> > > records ( or none ) on the same key.
> > >
> > > I need left join(?) syntax which will allow me to get all of the
 multiple
> > > records in the second file attached to each of the unique records in the
> > > first file, always having the same total number of fields in each row of
 the
> > > result set.
> > >
> > > Any ideas?
> >
> > Yes.
> >
> > Forget doing what you say you want to do. Writing a view against two other
 views
> > is going to be so slow you will regret having ever had the idea.
> >
> > Instead sit down with the SQL used to create the other views and create a
 new
> > view that does what you want. And remember NVL() is your friend.
> >
> > Daniel A. Morgan
> >
Received on Thu Apr 26 2001 - 00:18:28 CDT