Hi all.
I have a requeriment and will ilustrate it using 3 tables:
1 s24_perspectiva_periodo (Only shown required for ilustration).
ID_REGISTRO NOT NULL NUMBER
PCM_ID_PERSPECTIVA NOT NULL NUMBER
PGT_ID_PERIODO_GESTION NOT NULL NUMBER
PER_ID_PERSONA_RESPONSABLE NUMBER
TX_DESCRIPCION_META VARCHAR2(500)
VA_META NUMBER
2. s24_objetivo_periodo (Only shown required for ilustration).
ID_REGISTRO NOT NULL NUMBER
OBE_ID_OBJETIVO NOT Ns24_objetivo_periodoULL NUMBER
PCD_ID_PERSPECTIVA_PERIODO NUMBER
OBD_ID_OBJETIVO_PADRE_PERIODO NUMBER
PER_ID_PERSONA_RESPONSABLE NUMBER
TX_DESCRIPCION_META VARCHAR2(200)
PGT_ID_PERIODO_GESTION NOT NULL NUMBER
VA_META NUMBER
3. S24_INDICADOR_PERIODO_R
ID_REGISTRO NOT NULL NUMBER
INC_ID_INDICE NOT NULL NUMBER
ID_REFERENCIA NOT NULL NUMBER
NB_TABLA NOT NULL VARCHAR2(30)
VA_INDICE NOT NULL NUMBER
UNM_ID_UNIDAD_MEDIDA NUMBER
OBD_ID_OBJETIVO_PERIODO NUMBER
PC_CONTRIBUCION NUMBER
VA_META NUMBER
The relationship is as follows: s24_objetivo_periodo is a child of s24_perspectiva_periodo on (ID_REGISTRO = PCD_ID_PERSPECTIVA_PERIODO ) and S24_INDICADOR_PERIODO_R is a child of s24_objetivo_periodo on (ID_REGISTRO = OBD_ID_OBJETIVO_PERIODO).
I want a query the returns for every record of the grand parent table, all of his descendants (rows from s24_objetivo_periodo and later all rows from S24_INDICADOR_PERIODO_R) and also if its possible to create a sort of pseudo parent (where of rows are subordinate) named "Company".
Is that possible? Any ideas????
Thanks in advance!!!!