SQL 创建VIEW范例

CREATE OR REPLACE VIEW ZELTV_WAREIO
(warehouse_io_id, warehouse_int_no, product_info_id, product_no, prdt_size_gp, k3_product_id, color_id, size_group, product_num, type, io_create_date, io_create_time, person_id, tm_warehouse_id, ware_bill_no, ware_no, ware_name, up_flag, mark_for_delete, create_by, create_date, create_time, update_by, update_date, update_time, ware_io_type, io_expire_date, io_expire_time, stock_now_after, cost_after, src_rec_id, unit_price)
AS
SELECT T.SC_TT_WAREHOUSE_IO_ID,
       T.WAREHOUSE_INOUT_NO,
       T.SC_TM_PRODUCT_INFO_ID,
       p.product_no,
       a.attribute_value,
       p.k3_product_id,
       p.color_id,
       p.product_size,
       T.PRODUCT_NUM,
       T.TYPE,
       TO_CHAR(T.IO_CREATE_DATE, 'YYYYMMDD'),
       TO_CHAR(T.IO_CREATE_DATE, 'HH24MISS'),
       T.PERSON_ID,
       T.SC_TM_WAREHOUSE_ID,
       T.SC_TT_BAK1,
       T.SC_TT_BAK2,
       T.SC_TT_BAK3,
       T.SC_TT_BAK4,
       T.MARK_FOR_DELETE,
       TO_CHAR(T.CREATE_BY),
       TO_CHAR(T.CREATE_DATE, 'YYYYMMDD'),
       TO_CHAR(T.CREATE_DATE, 'HH24MISS'),
       TO_CHAR(T.UPDATE_BY),
       TO_CHAR(T.UPDATE_DATE, 'YYYYMMDD'),
       TO_CHAR(T.UPDATE_DATE, 'HH24MISS'),
       T.WARE_IO_TYPE,
       TO_CHAR(T.IO_EXPIRE_DATE, 'YYYYMMDD'),
       TO_CHAR(T.IO_EXPIRE_DATE, 'HH24MISS'),
       T.STOCK_NOW_AFTER,
       T.COST_AFTER,
       T.SRC_REC_ID,
       T.UNIT_PRICE
  FROM SC_TT_WAREHOUSE_IO T
  left join sc_tm_product_info p
    on t.sc_tm_product_info_id = p.sc_tm_product_info_id
  LEFT JOIN sc_tm_product_attribute A
    ON T.SC_TM_PRODUCT_INFO_ID = A.SC_TM_PRODUCT_INFO_ID
   AND A.ATTRIBUTE_ID = 'MAP_KEY_PRDT_SIZE_GP';