Posted by josh@pixael.com on September 28, 2009 at 9:23pm
hi guys
do you know why if i add a groupby user_uid for this query:
SELECT node.nid AS nid,
users.uid AS users_uid,
node.nid AS node_nid
FROM node node
INNER JOIN users users ON node.uid = users.uid
WHERE node.type in ('review')
ORDER BY node_nid DESChook_views_query_alter add all rows in group by?
SELECT node.nid AS nid,
users.uid AS users_uid,
node.nid AS node_nid
FROM node node
INNER JOIN users users ON node.uid = users.uid
WHERE node.type in ('review')
GROUP BY users_uid, nid, node_nid
ORDER BY node_nid DESC
Comments
Maybe because you selected these items
If you select items without max(), min(), sum() etc. you HAVE to put them in the group by clause (otherwise it would be a bingo what value to present for nid or node_nid).