Dear all Please see the attached screen shot of the query and the output. I am almost there but I have run out of ideas on what I can do to post process further.
My final output I want something like this: 1 Haemogram Report 1 Routine Haemogram 1 Haemogram Report 5 Diff. Count (Mature Cells) 1 Haemogram Report 10 Special Investigations 5 Haemogram Report 1 E.S.R. 3 C-Reactive Protine 1 4 Urine Analysis 1 Physical Examination 4 Urine Analysis 8 Chemical Examination 4 Urine Analysis 10 Microscopic Examination of Centrifugalised Deposit ie. The Row 4 is clubbed with row 2 and row 9 becomes row 4 The idea is that all the cTitle are clubbed together but in the order they were originally selected, thus MIN(A.iSrNo). The second grouping is cSubGroup, together but in the order they were defined, thus MIN(C.iSrNo) Please advise Kind regards Bhavbhuti