i have two tables with same structures and datatypes. One contains current data and other contains history data of the first one. I want to fetch records using both tables on some conditions without using procedures. Can I ?
Union is not allowed in creating VIEW??? why?
may be your ASE version is low.
i execute below statement in my 12.5.1 ASE
1> create table a1 (a int)
1> create table a2 (a int)
1> create view va(a) as
2> select * from a1 union select * from a2
1> select * from a1, va where a1.a = va.a