SELECT dbo.BookInfo.bookid,
SUM(dbo.Sale.s_quantity) AS Expr13,
SUM(dbo.Receive.r_quantity) AS Expr12
FROM dbo.BookInfo
LEFT JOIN dbo.Sale
ON(dbo.BookInfo.bookid = dbo.Sale.bookid)
LEFT JOIN dbo.Receive
ON(dbo.BookInfo.bookid = dbo.Receive.bookid)
GROUP BY dbo.BookInfo.bookid
试一下我记得原来我用过是好用的。
SUM(dbo.Sale.s_quantity) AS Expr13,
SUM(dbo.Receive.r_quantity) AS Expr12
FROM dbo.BookInfo
LEFT JOIN dbo.Sale
ON(dbo.BookInfo.bookid = dbo.Sale.bookid)
LEFT JOIN dbo.Receive
ON(dbo.BookInfo.bookid = dbo.Receive.bookid)
GROUP BY dbo.BookInfo.bookid
试一下我记得原来我用过是好用的。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货