Re: SQL help, Please???

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 24 Apr 2001 23:04:47 -0700
Message-ID: <3AE668FF.426F93AD@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 - 01:04:47 CDT