select inSupplier,sum(inTotalmoney) as b, sum(inPaymoney) as c from invoiceInfo where month(inDuedate)='"&monthnow&"'这样不就得了？
