> If this worked: > > select fname, chng from t1 > where fname like 'file%' > group by fname > having vers = max(vers) Yes, indeed it would :)
> select fname, chng > from t1 > inner join (select fname, max(vers) as maxvers from t1 where fname > like 'file%' group by fname) maxvers on > t1.fname = maxvers.fname and t1.vers = maxvers.maxvers > This works fine, well almost that is ;) SQLite was complaining about fname being ambigous so I changed first line to: select t1.fname, chng Now it works. Thanks John :) -- Nemanja Corlija <[EMAIL PROTECTED]>
