query problem

[bhushan98]

Hello Everybody,

I am having a table and the sample data is as follows :

ord_no tr_date party itemname fab ref cref col1 col2 col3 col4 size1 pcsize1 size2 pcsize2 size3 pcsize3 size4 pcsize4 size5 pcsize5 size6 pcsize6 rate
 
 
1111 6/3/2009 ALBERT JUGNU TOP LONG SLEEFS =XS CAMBRIC 123 12234 HEENA CHOCO BROWN RED S-Small 10 M-Medium 20 L-Large 30 XL-Extra Large 40 FS-Free Size 50 FS-Free Size 60 120
 
 
 
1111 6/3/2009 ALBERT KAMAL HOLE TOP M=S HANDLOOM 123 12 HEENA CHOCO BROWN RED S-Small 5 M-Medium 20 L-Large 30 XL-Extra Large 40 FS-Free Size 50 FS-Free Size 60 120

The desired output is like :

eg.

Fabric         color        Nos
 
CAMBRIC       HEENA     (SUM OF ALL PCSIZE1-6 FIELDS)
CAMBRIC       CHOCO    (SUM OF ALL PCSIZE1-6 FIELDS)
CAMBRIC       BROWN    (SUM OF ALL PCSIZE1-6 FIELDS)
HANDLOOM    HEENA     (SUM OF ALL PCSIZE1-6 FIELDS)
HANDLOOM    RED         (SUM OF ALL PCSIZE1-6 FIELDS)

Pl. Help me to find a solution to this query.

Thanks and Regards


Neeraj

[RuralGuy]

Is there any chance you could nornalize this table?