M
Mattias
Hi
Need pro assistance with this select query...
I am going to use it as a recordset to loop throw with code later. Have one
problem with the query though to make it usable..I would like it to be one
unique record on the left side and only one top value on the right side for
each unique recordnumber on the left side.
Posted the SQL below.
Thanks in advance...
Mattias
The query behaves like this now...
Left side: Right side:
record1 200.000:-
record1 100.000:-
record1 50:-
record2 1.000.000:-
record3 Null
record4 Null
And would like to be like this...
Left side: Right side:
record1 200.000:-
record2 Null
record3 50:-
record4 1.000.000:-
record5 Null
record6 Null
SELECT AuktionsrutinradFråga.OBJEKTMOTTAGNINGRAD,
AuktionsbudradAutobudFråga.Bud, AuktionsbudradAutobudFråga.BuddatumTid,
AuktionsbudradAutobudFråga.MaxBud
FROM AuktionsrutinradFråga LEFT JOIN AuktionsbudradAutobudFråga ON
AuktionsrutinradFråga.OBJEKTMOTTAGNINGRAD =
AuktionsbudradAutobudFråga.Objektmottagningrad
ORDER BY AuktionsrutinradFråga.OBJEKTMOTTAGNINGRAD,
AuktionsbudradAutobudFråga.Bud DESC ,
AuktionsbudradAutobudFråga.BuddatumTid;
Need pro assistance with this select query...
I am going to use it as a recordset to loop throw with code later. Have one
problem with the query though to make it usable..I would like it to be one
unique record on the left side and only one top value on the right side for
each unique recordnumber on the left side.
Posted the SQL below.
Thanks in advance...
Mattias
The query behaves like this now...
Left side: Right side:
record1 200.000:-
record1 100.000:-
record1 50:-
record2 1.000.000:-
record3 Null
record4 Null
And would like to be like this...
Left side: Right side:
record1 200.000:-
record2 Null
record3 50:-
record4 1.000.000:-
record5 Null
record6 Null
SELECT AuktionsrutinradFråga.OBJEKTMOTTAGNINGRAD,
AuktionsbudradAutobudFråga.Bud, AuktionsbudradAutobudFråga.BuddatumTid,
AuktionsbudradAutobudFråga.MaxBud
FROM AuktionsrutinradFråga LEFT JOIN AuktionsbudradAutobudFråga ON
AuktionsrutinradFråga.OBJEKTMOTTAGNINGRAD =
AuktionsbudradAutobudFråga.Objektmottagningrad
ORDER BY AuktionsrutinradFråga.OBJEKTMOTTAGNINGRAD,
AuktionsbudradAutobudFråga.Bud DESC ,
AuktionsbudradAutobudFråga.BuddatumTid;