Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
nop. the new field 'ordercnt' shows the same count as 'oecount', which is actually is the line item count from codet.
i think it has to do with the creation of the querry. since the sql looks at all the detail items (since they are connected to the header), it 'creates' n times the header record for each detail item.
i was think that maybe i need to create a subquerry in order to achive this. but i have no clue on how or where to start.
>Is this what you need?
>
>
>sele ;
> sum(b.usell*b.qtyord) as sales, ;
> count(a.oeno) as oecount, ;
>count(*) as ordercnt,;
>month(a.reqdate) as nmonth ;
> from comast a, codet b ;
> where ;
> a.oeno = b.oeno .and. ;
> "100" $ a.custclass .and. ;
> between(a.reqdate, {^2003/01/01}, {^2003/12/31}) ;
> group by nmonth
>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement