这句话错在什么地方?"Select baidu_records.ruser,baidu_user.zXed,sum(baidu_records.rJine) as jine From baidu_records left join baidu_user on baidu_records.ruser = baidu_user.uName Where baidu_records.rZtype = '" & "销" & "' group By baidu_rec
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/13 05:06:25
![这句话错在什么地方?](/uploads/image/z/10060344-0-4.jpg?t=%E8%BF%99%E5%8F%A5%E8%AF%9D%E9%94%99%E5%9C%A8%E4%BB%80%E4%B9%88%E5%9C%B0%E6%96%B9%3F%22Select+baidu_records.ruser%2Cbaidu_user.zXed%2Csum%28baidu_records.rJine%29+as+jine+From+baidu_records+left+join+baidu_user+on+baidu_records.ruser+%3D+baidu_user.uName+Where+baidu_records.rZtype+%3D+%27%22+%26+%22%E9%94%80%22+%26+%22%27+group+By+baidu_rec)
这句话错在什么地方?"Select baidu_records.ruser,baidu_user.zXed,sum(baidu_records.rJine) as jine From baidu_records left join baidu_user on baidu_records.ruser = baidu_user.uName Where baidu_records.rZtype = '" & "销" & "' group By baidu_rec
这句话错在什么地方?
"Select baidu_records.ruser,baidu_user.zXed,sum(baidu_records.rJine) as jine From baidu_records left join baidu_user on baidu_records.ruser = baidu_user.uName Where baidu_records.rZtype = '" & "销" & "' group By baidu_records.ruser"
这句话错在什么地方?"Select baidu_records.ruser,baidu_user.zXed,sum(baidu_records.rJine) as jine From baidu_records left join baidu_user on baidu_records.ruser = baidu_user.uName Where baidu_records.rZtype = '" & "销" & "' group By baidu_rec
baidu_user.zXed不在group by子句中,而且没有任何统计值,譬如max min什么的