Suppression of duplicate values in columns

[gamcall]

Hi there,
I've got a query which returns a result set like this:

ColA ColB ColC ColD
A1 B1 C1 D1
A1 B1 C2 D2
A1 B1 C3 D3
A2 B2 C4 D4

ie, multiple values of cols C & D for a value of A & B (which are 1 to 1). I want a result set of the form:

ColA ColB ColC ColD
A1 B1 C1 D1
C2 D2
C3 D3
A2 B2 C4 D4

ie, removal of the duplicate values of Cols A & B. Can anyone help? I've tried tricky combinations of UNION etc...

T.I.A,
GAM

 

[tlbroadbent]

You'll need to use a cursor in a procedure to do this. There are no SQL commands to compare values in a row to the previous row values.

Are you doing this for a report? If so, I recommend using a reporting tool like Crystal Reports or MS Access to produce the results you want. It will take less time to develop and
look better. Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

Why you do not put them in different tables? John Fill

ivfmd@mail.md

 

[lovalles]

i want to do the same thing that gamcall is trying to do.
gamcall Did you solve this.?
thanks
lovalles