물품입출고내역 재고수량 뷰 만들기
CREATE OR REPLACE VIEW PRODUCT_VIEW AS
SELECT P., PC. FROM PRODUCT P LEFT OUTER JOIN (
SELECT PRODUCT_NO, SUM(CNT) CNT FROM PRODUCTCOUNT GROUP BY PRODUCT_NO) PC
ON P.NO = PC.PRODUCT_NO;
CREATE OR REPLACE VIEW PRODUCT_VIEW AS
SELECT P.*, PC.CNT FROM PRODUCT P LEFT OUTER JOIN (
SELECT PRODUCT_NO, SUM(CNT) CNT FROM PRODUCTCOUNT GROUP BY PRODUCT_NO) PC
ON P.NO = PC.PRODUCT_NO;