Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>>>>>I am trying to build a view that totals an amount filed, I wish to have one column total be a YTD total and another column for just a particular day. I have tried using a join but that gives two rows for the result, I need one row with both totals.
>>>>>>>>
>>>>>>>>TIA
>>>>>>>>
>>>>>>>>Ian
>>>>>>>Make that a union not a join
>>>>>>
>>>>>>Union gives you new row(s). Do you really want to have columns? Could you post a sample of wishful query results.
>>>>>
>>>>>The view is to show the amount of a commodity delivered to a warehouse both YTD and today
>>>>>
>>>>>Commodity YTD delivered Today delivered
>>>>>Wheat 99999 11111
>>>>>
>>>>>Ian
>>>
>>>Firstly, excuse me for empty reply. Secondly, what do you have in base table? Do you have multiple commodities? It seems to me that cross-tab query will be part of solution.
>>
>>Yes there are multiple commoddities. What I think I am wondering is, is it possible to perform the query as follows:
>>
>>sum(amount) for dtdate < date() in one column and sum(amount) for dtdate = date() in a separate column.
>
>Don't rush, please! If you have multiple commodities then, I assume, you want to get many records (one for each commodity) in resulting cursor. Is this right?
Sorry about that!
Yes there are muliple commodities. Yes I do want one for each commodity
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