1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
select cpt_tiers.idas numerocpte,
limite_credit,
monnaie.nom as code_monnaie,
cond_pai.nom as cond_paiement,
client.taux_rabais as escompte,
tarif.nom as cond_vente
from co_compte_tiers cpt_tiers,
ad_monnaie monnaie,
co_cond_pmt cond_pai,
co_tiers tiers_ident,
int_client_per client,
as_tarif_ent tarif
where client.AS_TARENT_ID=tarif.id
and client.CO_COMPTE_TIERS_ID=cpt_tiers.ID
and cpt_tiers.AD_MONNAIE_ID=monnaie.ID
and cpt_tiers.COND_PMT_DEF=cond_pai.ID
and cpt_tiers.CO_TIERS_ID=tiers_ident.ID |
Partager