Problem with query

Last Post 30 Sep 2007 09:20 PM by trans53. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
trans53
New Member
New Member

--
29 Sep 2007 03:14 PM
Hi guys,

i have a little truble with this data:

Group fy06 fy07 cust06 orderst06 totalamt06 cust07 orders07 totalamt07
BUYER Admin NULL 1264 1760 81562.94 NULL NULL NULL
BUYER Anv NULL 33274 37190 1897568.69 NULL NULL NULL
BUYER NULL Admin NULL NULL NULL 695 901 44720.01
BUYER NULL Anv NULL NULL NULL 27648 30479 1588617.83
BUYER NULL Cong NULL NULL NULL 8162 9440 463749.02


i need to have 1 row per similar description.something like this:

Group fy06 fy07 cust06 orderst06 totalamt06 cust07 orders07 totalamt07
BUYER Admin Admin 1264 1760 81562.94 695 901 44720.01
BUYER Anv Anv 33274 37190 1897568.69 27648 30479 1588617.83
BUYER na/ Cong n/a n/a n/a 8162 9440 463749.02

Also, if there is no matching description i still want that data. Like Cong in this example.
It is possible to do this?

Thanks
trans53
New Member
New Member

--
30 Sep 2007 09:20 PM
Thank you so much
You are not authorized to post a reply.

Acceptable Use Policy