1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| SELECT TD_DW_SINISTRE.SOURCE, TD_DW_SINISTRE.ID_CTRTE,
TD_DW_SINISTRE.ID_PROD, TD_DW_SINISTRE.ID_OPT,
TD_DW_SINISTRE.ID_SOC, TD_DW_SINISTRE.ID_INTERV_DISTRIB,
TD_DW_SINISTRE.ID_STRUCT, TD_DW_SINISTRE.TYP_SIN,
TD_DW_SINISTRE.DT_PASS_POS_SIN, TD_DW_SINISTRE.ID_UNQ_ROL_ASS,
TD_DW_SINISTRE.ID_UNQ_CONT, TD_DW_SINISTRE.TYP_ENREG,
TD_DW_ROL_ASS.ID_UNQ_GEN_PROD, TD_DW_GEN_PRODUIT.ID_GEN_PROD,
TD_DW_PEC.SOURCE, TD_DW_PEC.TYP_ENREG, TD_DW_PEC.NUM_LOT_DE,
TD_DW_CONTRAT.ID_UNQ_INTERV, TD_DW_SINISTRE.PROV_SIN_PROB,
TD_DW_PEC.ID_UNQ_PEC, TD_DW_PEC.NUM_DEC, TD_DW_PEC.ID_UNQ_SIN,
TD_DW_CONTRAT.DT_SIGN_CONT, TD_DW_PROV_SIN.ID_UNQ_SIN
FROM
TD_DW_SINISTRE, TD_DW_PEC, TD_DW_GEN_PRODUIT, TD_DW_ROL_ASS,
TD_DW_CONTRAT, TD_DW_PROV_SIN,
(select xxx from tes_tables where ...) tmp
WHERE |
Partager