Re: SQL help, Please???

"decent" may be the operative word...

I work for a third-party real estate software company. The Multi-Listing Service which has the data allows ONLY access to the views. I interface MLS data from all over the country in a variety of formats into our dBaseIV files. Everything from text based downloads to exported db file to ODBC like this on.

If I wasn't already pretty far over the line, this would drive me nuts!

--

Lynn C. Ormond
Lucero Research
Reply to: Lynn_at_Lucero.com


Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message
news:3AE7AFA4.BCCB215D_at_exesolutions.com...


> 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

> > >

>