>Is it possible to make view as follows:?
>SELECT * FROM table1 ;
>UNION ;
>SELECT * FROM table2
>
>Where table1 and table2 has identical structure.
>
>Giedrius
Hi Giedrius,
Yes you could do it just by adding "create sql view myViewName as .." in front. In view designer no way to do it AFAIK. I'm not sure of this but IMHO that would be practically a nonUpdatable view and hence not much different from an editable cursor (except that you could set some properites directly in DBC where for an editable cursor you should redo it on the fly).
Cetin