ÓÐÁ½¸ö±í£¬Ò»¸öÊÇÉÌÆ·±íalpro ID int 4 ¶¨ÒåͼÊéidºÅ lb varchar 20 ¼Ç¼ͼÊéËùÊôÀà±ð shuliang int 4 ¼Ç¼ͼÊéµÄ¿â´æ price2 float ¼Ç¼ͼÊéµÄ¼Û¸ñ Ò»¸öÊÇÏúÊÛ±íxse proid ¼Ç¼ÏúÊÛͼÊéµÄid sl ¼Ç¼ÏúÊÛµÄÊýÁ¿ addtime ¼Ç¼ͼÊéÏúÊÛµÄʱ¼ä Ïë×öÒ»¸öÊÓͼ£¬¾ÍÊǰ´ÉÌÆ·µÄÀà±ð¼ÆËã³öÿ¸öÔÂÿÖÖÀà±ðÉÌÆ·ÏúÊ۵Ľð¶î¸øµã²âÊÔÊý¾Ý°É£¡~~ select a.lb ,sum(isnull(a.price2,0)*isnull(b.sl,0)) as price from xse b left join alpro a on a.ID = b.proid group by a.lb,convert(varchar(6),b.addtime,112)