jfquestiaux
Well-Known Member
I know the tooltip refers only to WHERE and ORDER, but I noticed this in the "Joins where and/or
order by statement (SQL)" of the databasejoin element:
This statement returns correct data:
WHERE actor_id = 9 GROUP BY user_id
But this one returns an SQL error (1064 - You have an error in your SQL syntax) :
GROUP BY user_id
So it seems that GROUP BY works only when associated with WHERE, because this:
ORDER BY full_name ASC GROUP BY user_id
Returns also an SQL error.
Unfortunately, it is this last statement I'd need. Is it possible ?
Tested is 3.1RC1 - GitHub 5
order by statement (SQL)" of the databasejoin element:
This statement returns correct data:
WHERE actor_id = 9 GROUP BY user_id
But this one returns an SQL error (1064 - You have an error in your SQL syntax) :
GROUP BY user_id
So it seems that GROUP BY works only when associated with WHERE, because this:
ORDER BY full_name ASC GROUP BY user_id
Returns also an SQL error.
Unfortunately, it is this last statement I'd need. Is it possible ?
Tested is 3.1RC1 - GitHub 5