From: Jeremy Shaw <Jeremy.S<haw@li...>  20040509 21:02:53

Hello, I am not quite sure what the best way to do the following in haskelldb is: Here is the query in SQL: select column1 from table1 where column2 =3D (select max(column2) from table1); Basically, I want to find the value in column1 that is in the same row as the maximum column2 value. In this case, column2 is a unique key. I could do this as two seperate queries haskelldb,=C2=A0 one to find the m= ax column2 value, and a second query to find the corresponding column1 value  but it would be nice to do it all in one step. I imagine I might also be able to hack something up by using sort and top  but that seems a bit hackish when the actual SQL I want to generate is pretty straight forward. Any ideas? Thanks! Jeremy Shaw. 