我有SQL代码,它会抛出一个错误
select * left join labtrans on labtrans.refwo=workorder.wonum and labtrans.siteid=workorder.siteid
left join matusetrans on workorder.wonum=matusetrans.refwo and workorder.siteid=matuse
在视图中运行的sql查询如下:
SELECT node.changed AS node_changed, node.nid AS nid, SUM(search_index.score * search_total.count如果我将'GROUP BY search_index.sid,score,node_changed,nid‘替换为GROUP nid,则查询非常有效。我怎样才能做到这一点?