>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 max(pk),max(title),max(body),max(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.
In other words, all fields not listed in Group By should have some aggregate function. If these fields are memo fields, then you're out of luck.
If it's not broken, fix it until it is.
My Blog