9 lines
414 B
SQL
9 lines
414 B
SQL
create view vi_insuranceinfo_first_transfer as SELECT APZL.LC_CALC_CONDITION.CONTRACT_ID AS CONTRACT_ID, min(APZL.LC_CALC_CONDITION.START_DATE) AS STARTDATE
|
|
FROM APZL.LC_CALC_CONDITION
|
|
GROUP BY APZL.LC_CALC_CONDITION.CONTRACT_ID;
|
|
|
|
-- comment on column vi_insuranceinfo_first_transfer.contract_id not supported: 合同编号
|
|
|
|
-- comment on column vi_insuranceinfo_first_transfer.startdate not supported: 起租日
|
|
|