I am having a problem with generating sql statement(s) using
outer joins for views on a set of tables, the scenario is
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
----- ------ -----
R P G
----- ----- -----
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.