qbe icon indicating copy to clipboard operation
qbe copied to clipboard

Query generation error -- Query generator can't make grouping by Foreign Key fields

Open MikeVelazcoMtz opened this issue 11 years ago • 3 comments

The query generator fails and assign the column name as the alias, or at least that I suppose. http://youtu.be/ypkOp71Cnes

MikeVelazcoMtz avatar Oct 09 '14 23:10 MikeVelazcoMtz

I've been checking this error, what happens in reality is that the query generator can't make grouping by Foreign Key fields

MikeVelazcoMtz avatar Oct 10 '14 15:10 MikeVelazcoMtz

I'll take a look. Thanks.

versae avatar Oct 13 '14 21:10 versae

I think that the problem is the COUNT(*), that does not work with when grouping by.

versae avatar Jan 05 '15 02:01 versae