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
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