Re: SQL-statements , outer-joins

How about:

select core.unique_id, plane.depth,

          o1.data "Content1 Name", o2.data "Content2 Name", ...   from core, plane, contents, observation o1, observation o2, ...  where contents.core = core.unique_id
   and plane.core = core.unique_id
   and plane.unique_id = o1.plane (+)
   and contents.unique_id = o1.contents (+)    and plane.unique_id = o2.plane (+)
   and contents.unique_id = o2.contents (+)    ...
order by core.unique_id, plane.depth

Question: why does the contents table have a foreign key to core? Aren't the contents the same across cores? Or do you want different tables for each core (in which case the above obviously doesn't work very well)?

Another option -- will SQL*Reportwriter matrix reports work? Received on Fri Feb 25 1994 - 23:06:19 CET