select d.dataName From paymoney pm Left Join ProjectInfo pro On pro.ProjectNo = pm.payProjectNo Left Join DataDictory d On d.DataId = pro.RecommendComPany
----查询结果为合作银行推荐---正常结果
仅把create 改为 alter 修改视图后,在使用select dataName from v_RecommendTypeRepayMoney
----查询结果为合作银行推荐---正常结果
------解决方案--------------------
重新建立个视图看看是否会有问题!
create view v_1 as select d.dataName From paymoney pm Left Join ProjectInfo pro On pro.ProjectNo = pm.payProjectNo Left Join DataDictory d On d.DataId = pro.RecommendComPany