I am having a problem with generating sql statement(s) using
outer joins for views on a set of tables, the scenario is
described below:
(Notation:
Cap Letter with underlining: Table Name
> (horizontal/vertical indiates relaion
LHS of relation M:Nt means: m to n rows of table t
can be related with:
RHS of relation M:Nt means: m to n rows of table t
0:N means null relation is possible
)
U T E
  
1:1u>1:Mt 1:1t>0:Me
1:1t

V
0:1r
R P G
  
1:Mr>1:1p 1:Mp>1:1g
Apparently, the above situation is forcing me to use at least
two outer joins (since the data is needed even on null
relation), one between T>E and another between T>R.
The sql server is * on sql statement to join these
different tables in one or more levels of views.
The join is expected to select columns from all but table 'R'.
I would sincerely appreciate any suggestions/solutions.
thanks.