On 3 September 2013 11:42, Bassem Bouguerra <[email protected]> wrote:
> I am sorry. I am trying to groupby and not orderby. > I want to select from 2 tables and groupby the id of one table. This works > fine in sqllight but throws an error on postgresql. > > You cannot do that in Postgresql. If you want to group by in Postresql you have to use all the fields in the groupby part that was used in the 'select' part of the query. Regards Johann -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
