sqlYoga question

Bob Sneidar bobsneidar at iotecdigital.com
Mon Jul 17 20:00:11 EDT 2023

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

More information about the use-livecode mailing list