一般我们建立视图会这样create view 视图名 as ( 语句)
对于涉及到union的视图创建,括号就不要了。如下
CREATE view v_HPF_JSKZ_BHFWJSKZDD1HPF_JSKZ_YCQHCQ as select a.*,b.YCMC from HPF_JSKZ_BHFWJSKZDD1HPF_JSKZ_YCQHCQ a RIGHT JOIN HPF_YCJCXX_YBML b on a.GLYCBTID = b.YCBM union select a.*,b.YCMC from HPF_JSKZ_BHFWJSKZDD1HPF_JSKZ_YCQHCQ a RIGHT JOIN HPF_YCJCXX_SJWHYC b on a.GLYCBTID = b.BM