General information
Category:
Coding, syntax & commands
>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only