请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘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/05/12 10:47:34
请帮忙看看这个查询语句,运行不了!提示错误!“在关键字‘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 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