sqlYoga question

[Bob Sneidar]

Hi ll. 

I have a curious problem. I am trying to select only records with the highest value in an SQL table. I know the SQL to do it, but how to get sqlYoga to do it is a mystery to me. The actual SQL looks something like this:

select * from files t1 
   where custid = '289' and fileversion = (select max(fileversion) from files t2 where t2.filename = t1.filename)

I know I can do this in the native API, but the question is, how to do this in sqlYoga?? 

Bob S