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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode