摘要： 关于分组和表关联的SQL语句： select distinct cameraman.cid,cameraman.username as username,count(*) as count from c_images left join cameraman on c_images.cid=cameraman.cid where cameraman.cid=1 group by username多... 阅读全文