涉及计算结果的连接查询

create view petmessage
as

select m.userid,
m.petname,
p.yuanbao,
sum(f.food_quantity) as quantity1,
sum(c.clean_quantity)as quantity2,
sum(d.drugs_quantity)as quantity3,
sum(t.toy_quantity)as quantity4,
a.inteeligence,
a.military,
a.charm,
a.active,
fa.loveno
from messages m
join propertys p
on m.userid=p.userid
 join food f
on p.userid= f.userid
join clean c
on f.userid=c.userid
 join drugs d
on c.userid=d.userid
 join toy t
on d.userid=t.userid
 join attribute a
on t.userid=a.userid
 join  family fa
on a.userid=fa.userid
group by m.userid,
m.petname,
p.yuanbao,
a.inteeligence,
a.military,
a.charm,
a.active,
fa.loveno 

由于涉及计算结果，所以必须分组显示，就是蓝色字体部分。其中每个表中的userid都不能为空