1 2 3 4 5 6 7 8 9 10 11 12 13
| select * from contrat o, contrat_produit_ligne c,lignes l,detail_ligne d, detail_ligne d2,tiers t1,tiers t2
where o.CTR_DATE_FIN>='25/01/2007'
and o.ID_CODE_CONTRAT=c.ID_CODE_CONTRAT
and o.ID_NO_AVENANT=c.ID_NO_AVENANT
and c.ID_DATE_CESSATION='01/01/1901'
and c.ID_NO_LIGNE=l.ID_NO_LIGNE
and l.ID_NO_LIGNE=d1.ID_NO_LIGNE
and d1.ID_NO_DETAIL_LIGNE=10
and l.ID_NO_LIGNE=d2.ID_NO_LIGNE
and d2.ID_NO_DETAIL_LIGNE=20
and t1.ID_CODE_TIERS=d1.dtl_code_tiers
and t2.ID_CODE_TIERS=d2.dtl_code_tiers
and (t1.ID_CODE_TIERS in (1, 51, 4) or t2.ID_CODE_TIERS in (1, 51, 4)) |
Partager