total_num.sql

Visual Basic + Oracle 9i数据库应用系统开发与实例（企业购销存管理系统）界面简洁,数据库完整,还不错~适合学生利用和使用!

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