Re: SQL help, Please???

From: Lynn C. Ormond <lynn_at_lucero.com>
Date: Wed, 25 Apr 2001 08:43:14 -0700
Message-ID: <4qCF6.2081$Pc3.300931@mick.cybertrails.com>

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 Wed Apr 25 2001 - 10:43:14 CDT