请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘group’附近有语法错误.Contiue”select a.bm,a.mc,count(b.auto_flag),count(c.branch_no) from zfl a left join t_bd_item_info b left join t_im_branch_stock con a.bm=le
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 05:24:58
![请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘group’附近有语法错误.Contiue”select a.bm,a.mc,count(b.auto_flag),count(c.branch_no) from zfl a left join t_bd_item_info b left join t_im_branch_stock con a.bm=le](/uploads/image/z/14455952-8-2.jpg?t=%E8%AF%B7%E5%B8%AE%E5%BF%99%E7%9C%8B%E7%9C%8B%E8%BF%99%E4%B8%AA%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%2C%E8%BF%90%E8%A1%8C%E4%B8%8D%E4%BA%86%21%E6%8F%90%E7%A4%BA%E9%94%99%E8%AF%AF%21%E2%80%9C%E5%9C%A8%E5%85%B3%E9%94%AE%E5%AD%97%E2%80%98group%E2%80%99%E9%99%84%E8%BF%91%E6%9C%89%E8%AF%AD%E6%B3%95%E9%94%99%E8%AF%AF.Contiue%E2%80%9Dselect+a.bm%2Ca.mc%2Ccount%28b.auto_flag%29%2Ccount%28c.branch_no%29+from+zfl+a+left+join+t_bd_item_info+b+left+join+t_im_branch_stock+con+a.bm%3Dle)
请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘group’附近有语法错误.Contiue”select a.bm,a.mc,count(b.auto_flag),count(c.branch_no) from zfl a left join t_bd_item_info b left join t_im_branch_stock con a.bm=le
请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘group’附近有语法错误.Contiue”
select a.bm,a.mc,count(b.auto_flag),count(c.branch_no) from zfl a left join t_bd_item_info b left join t_im_branch_stock c
on a.bm=left(b.item_clsno,4) and b.status
请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘group’附近有语法错误.Contiue”select a.bm,a.mc,count(b.auto_flag),count(c.branch_no) from zfl a left join t_bd_item_info b left join t_im_branch_stock con a.bm=le
select a.bm,a.mc,count(b.auto_flag),count(c.branch_no) from zfl a
left join t_bd_item_info b on a.bm=left(b.item_clsno,4) and b.status