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"
