bobsneidar at iotecdigital.com
Mon Jul 17 20:00:11 EDT 2023
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??
More information about the use-livecode