repost Help with Select query

  • Thread starter Thread starter Mattias
  • Start date Start date
M

Mattias

Hi

I do not want to change any data!!

It just an example. If record2 is Null it is ok.
if record2 has 1.000.000 and it is the only one on the right side, it is
also ok.
If record2 has 1.000.000 and one more record on right side: 1.500.000..then
I would like the query only to show top value "1.500.000" on the right side.

Mattias
 
Back
Top