Views with Outer Join

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 Fri Jan 05 2001 - 15:04:58 CST