<span style="color: rgb(51, 51, 255);">Hi All.</span><br style="color: rgb(51, 51, 255);" /><br style="color: rgb(51,
51,255);" /><span style="color: rgb(51, 51, 255);">Can help to create sql queries for this data :</span><br
style="color:rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><span style="color: rgb(255, 0, 0);">tabel
A</span><brstyle="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">field1, field2, field3</span><br
style="color:rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">x1, y1, 5</span><br style="color: rgb(255,
0,0);" /><span style="color: rgb(255, 0, 0);">x1, y2, 1</span><br style="color: rgb(255, 0, 0);" /><span
style="color:rgb(255, 0, 0);">x2, y1, 2</span><br style="color: rgb(255, 0, 0);" /><span style="color: rgb(255,
0,0);">x2, y3, 4</span><br style="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">x1,
y3, 4</span><br style="color: rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><span style="color:
rgb(51,51, 255);">I want to get 2 record with the max value at field3 for each kombination of field1 :</span><br
style="color:rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><span style="color: rgb(255, 0, 0);">tabel
B</span><brstyle="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">field1, field2, field3</span><br
style="color:rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);"> x1, y1, 5</span><br style="color:
rgb(255,0, 0);" /><span style="color: rgb(255, 0, 0);"> x1, y3, 4</span><br style="color: rgb(255, 0, 0);"
/><spanstyle="color: rgb(255, 0, 0);"> x2, y3, 4</span><br style="color: rgb(255, 0, 0);" /><span style="color:
rgb(255,0, 0);"> x2, y1, 2</span><br style="color: rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);"
/><spanstyle="color: rgb(51, 51, 255);">Anyone have an ideas?</span><br style="color: rgb(51, 51, 255);" /><span
style="color:rgb(51, 51, 255);">Thanks anyway.</span><br clear="all" /><br />-- <br
/>-------------------------------------------------------------------<br/> "He who is quick to become angry will commit
folly,and a crafty man is hated"<br />