220419

물품입출고내역 재고수량 뷰 만들기

• 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;