CREATE OR REPLACE VIEW TOTAL_NUM AS
SELECT OSSMAN.ProInStore.ProId, SUM(OSSMAN.ProInStore.ProNum) AS Total
FROM OSSMAN.ProInStore INNER JOIN
OSSMAN.Product ON (OSSMAN.ProInStore.ProId = OSSMAN.Product.ProId)
GROUP BY OSSMAN.ProInStore.ProId;
SELECT OSSMAN.ProInStore.ProId, SUM(OSSMAN.ProInStore.ProNum) AS Total
FROM OSSMAN.ProInStore INNER JOIN
OSSMAN.Product ON (OSSMAN.ProInStore.ProId = OSSMAN.Product.ProId)
GROUP BY OSSMAN.ProInStore.ProId;
ON表示通过什么字段联系到一起。你写的VIEW是因为缺少了字段的信息,所以不对。CREATE OR REPLACE VIEW TOTAL_NUM
(ProId,Total)
AS
SELECT
OSSMAN.ProInStore.ProId, SUM(OSSMAN.ProInStore.ProNum) AS Total
FROM OSSMAN.ProInStore
INNER JOIN OSSMAN.Product
ON OSSMAN.ProInStore.ProId = OSSMAN.Product.ProId
GROUP BY OSSMAN.ProInStore.ProId;
AS
SELECT SALE.SHOPID AS SHOPID, SUM(SALE.SALENUM) AS Total
FROM SALE INNER JOIN
T2 ON SALE.SHOPID = T2.SHOPID
GROUP BY SALE.SHOPID;
CREATE OR REPLACE VIEW TOTAL_NUM AS
SELECT OSSMAN.ProInStore.ProId, SUM(OSSMAN.ProInStore.ProNum) AS Total
FROM OSSMAN.ProInStore,OSSMAN.Product
where OSSMAN.ProInStore.ProId = OSSMAN.Product.ProId
GROUP BY OSSMAN.ProInStore.ProId;
主要是为了套SQL标准,join关键字符合ISO/ANSI标准