Does anyone know if it's possible to create a view from two
views using an outer join? So far, it doesn't seem to work. The
result set is the same as an inner join.
I was going crazy trying to figure out what was happening in
To make things simpler to understand, I created 2 simple tables
with 3 columns each. I created a view from these tables, with
outer join and the result set was as expected.
I then created 2 views, one from each of my original 2 tables
that contained all columns from the original tables.
In other words, each view was identical to the table
it was derived from.
When I then created a view from these views with an OJ, the
result set was not correct.
Is this technically not possible, due to the way views work, or
have I discovered yet another bug? Using Watcom 4.0