Hi all,

I'm having a group by clause error with the following sql syntax, which I can't solve w/o setting the enginebehavior to 70 :

lcSql = [select blogname,author,tblEntries.*, ALLTRIM(SUBSTR(basepath,AT("/",basepath)+1)) as gebruiker ] + ;
        "from blog_config " +;
         "left outer join (select pk,title,body,abstract,blogpk,MAX(entered) as entered from blog_entries group by blogpk)  tblEntries " +;
         "on blog_config.pk=tblEntries.blogpk " 
&lcSql

How can I change the sql so things works as expected? Thanks beforehand.