Report and master detail.

From: C Marc <cmarcoux_at_webnet.qc.ca>
Date: Sun, 10 Dec 2000 17:20:49 GMT
Message-ID: <RXOY5.556$Wd4.48900652_at_news1.mtl.metronet.ca>

Hi.

Can anybody tell me If I forgot something.

When I run this SQL in SQL*Plus it give me all the details lines that correspond to the master COMCLI.

When I run it with Report it only give me the first line of the detail section.
Why?

select c.id_com,

    c.dat_com,
    c.dat_liv_com,
    c.id_ven,
     c.nom_ven,
     c.id_ter,
     c.des_ter,
     c.exp_com,
    c.exp_a_com,
     c.id_gar,
     c.des_gar,
     c.id_cli,
     c.nom_cli,
     d.id_ser_ite,
     d.id_ite,
     d.des_ite,
    d.qte_com_dco,
     d.qte_liv_dco,
     d.qte_bo_dco

 from comcli c, dcocli d
 where c.id_com = 1
 and d.id_com = c.id_com
/
Thanks you
please reply to cmarcoux_at_webnet.qc.ca Received on Sun Dec 10 2000 - 18:20:49 CET