>Is it possible to make view as follows:?
>SELECT * FROM table1 ;
>UNION ;
>SELECT * FROM table2
>
>Where table1 and table2 has identical structure.
Sure, although it would have to read more like...
SELECT * FROM table1 ;
UNION ( ;
SELECT * FROM table2 )
If you want to include all records from both tables, use UNION ALL