Hi All.
Can help to create sql queries for this data :
tabel A
field1, field2, field3
x1, y1, 5
x1, y2, 1
x2, y1, 2
x2, y3, 4
x1, y3, 4
I want to get 2 record with the max value at field3 for each kombination of
field1 :
tabel B
field1, field2, field3
x1, y1, 5
x1, y3, 4
x2, y3, 4
x2, y1, 2
Anyone have an ideas?
Thanks anyway.
--
-------------------------------------------------------------------
"He who is quick to become angry will commit folly, and a crafty man is
hated"