Re: Views with Outer Join

Not sure whether this will resolve this, but this is the way I try to conceptualize your problem

You have

table2 ->> table3 ->> table4 ->>(+) table5 <<- table1

Correct?

You now problably have an inner join between table5 and table1. There the confusion starts, because it looks like this should be an outer join too. However, you can't have an outer join on *both* sides of table5. Could you provide a *small* set of problem data. As your output seems to garble, if you can export it as comma delimited and text columns quoted.

Regards,

Sybrand Bakker, Oracle DBA

<bjornlindstrom_at_my-deja.com> wrote in message news:935ctk$77n$1_at_nnrp1.deja.com...
> Hi,
>
> First, an example of what I have to work with:
>
> Table1: Table2: Table3: Table4:
> CustomerID ManufacturerID ModelID ManufacturerID
> Name Name Name ModelID
> Specs
>
> Table5:
> CustomerID
> ManufacturerID
> ModelID
> SerialID
>
> I am having an interesting problem.
>
> I want to select all Models and Specs for a specific Manufactuer, plus
> show the Customers Name and Serial#'s for a specific customer owning
> Models by that Manufacturer.
>
> I link Table2 and Table3 to Table4 as normal, and Table4 as an outer
> join to Table5 using ManufacturerID and ModelID as the link. I will
> indeed get all Models and Specs if I don't specify the CustomerID.
>
> The problem is that as soon as I specify the CustomerID, the view
> immediately limits the output to only the Models that customer has
> records for in Table5!
>
> It is as if the view applies the specific ID to both the Table1 AND
> Table5 ...
>
> I am really frustrated by this. Has anyone else run into this before?
>
> Any suggestions as to how to get around this problem?
>
> Thanks in advance,
>
> Bjorn
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Jan 06 2001 - 03:29:45 CST