total_num.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例（企业购」· SQL 代码 · 共 6 行

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