create or replace view v_xxx2 as /* 创建或者替换视图 */
select
a."ZSBOOKID",a."FTFJ",a."NJSMJ",a."FZJG",a."BOOKID",a."ID",a."FZRQ",a."XMDM",a."CASENAME",
a."ITEMNAME",a."XMYJ",a."UNITNAME",a."CASEADD",a."YDMJ",a."NYDMJM",a."JSDWFR",a."JSDWFRSFZH",c."XYDM"
from v_xxx1 a left join table c
on a.id=c.id; /* 左关联的条件 */
-- 就是在v_xxx1视图的基础上加上table中条件吻合的数据
-- 既在v_xxx2的视图上增加列(c."XYDM")
--可以根据自己需求加列