create view v_test1 as select a,b,c,d,e,f,t1.b*t2.e from 表1 as t1 inner join 表2 as t2 on t1.aaa=t2.ddd 这两个表一定要有关联条件，进行内连接
