Error.SELECT b.name,b.con,COUNT(*) as count,a.name as bname,a.con as url,a.oper FROM branch a,city b WHERE a.cat='2206' AND a.a='1' AND b.id=a.city GROUP BY a.city ORDER BY b.name