semprolbat wrote:

>
> I have a view.. Stripped down to the essential fields,
> it looks a bit like:

> create view v_a as
> select a.id, a.mgrid, b.empid
> from t_a a
> left outer join t_c c on a.mgrid = c.mgrid
> left outer join t_b b on b.empid = c.empid
> ;

...

> Am I doing something wrong, or is this behaviour documented
> somewhere? Is the index messed up?
>
> I tried reproducing this with a test case, but in the test case
> everything works as expected.

My guess, like Set's , is that you've got some duplicate names in your
tables and the query compiler is getting a field from the wrong table in
processing the view. Try making your test case and your production case
more and more similar until the test case fails and you'll know where
your problem is. In otter words, my test case works too.


Regards,


Ann