View Single Post
  #7 (permalink)  
Old October 23rd, 2006, 12:58 PM
lethe lethe is offline
Authorized User
 
Join Date: Oct 2006
Location: , , .
Posts: 10
Thanks: 0
Thanked 1 Time in 1 Post
Default

There's another thing I want to do with this table.

Before, I wanted to list summaries by CompanyName. Now I want to list them by transaction Owner. Basically I want my output to look like this:

Code:
Owner1  JanTotalForOwner            FebTotal ...
Cond1   TotalForOwnerMatchingCond1  FebTotal ...
Cond2  ...
Owner2 JanTotalOwner2AllConditions  Feb
Cond1
Cond2
Is it clear what I want? To me, it really looks like a three dimensional result set. Is that even possible in SQL?

Reply With Quote