create view v1 as select * from TableA union select * from TableA minus select * from TableA where tableA.A1=tableB.A1 nution select a.A1,a.A2+b.A2,A3,B3 from TableA a,TableB b where a.A1=b.A1;
create view v1 as select * from TableA union select * from TableA minus select * from TableA where tableA.A1=tableB.A1 nuion select a.A1,a.A2+b.A2,A3,B3 from TableA a,TableB b where a.A1=b.A1;
select * from TableA union select * from TableA minus
select * from TableA where tableA.A1=tableB.A1 nution
select a.A1,a.A2+b.A2,A3,B3 from TableA a,TableB b where a.A1=b.A1;
select * from TableA union select * from TableA minus
select * from TableA where tableA.A1=tableB.A1 nuion
select a.A1,a.A2+b.A2,A3,B3 from TableA a,TableB b where a.A1=b.A1;