Re: Combining two tables into a view

From article <1r17scINN1kf_at_cronkite.cisco.com>, by pkane_at_diablo.cisco.com (Peter Kane):

> I have two tables with the same fields, such as:
>
> table1: so_num char(10), prod char(10), price number
>
> table2: so_num char(10), prod char(10), price number
>
> and I would like to create a view so that these two tables
> look like one table. I've tried creating a view where the
> 'as' clause has two selects and a 'plus' between them, but
> I couldn't get that to work.
>
> Any suggestions?

Yes: use SQL :-)

e.g.	create view gaga as
		select * from table1
		union	
		select * from table2

----
  __   __    Paul Singleton (Mr)           JANET: paul_at_uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul_at_cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 583477 << NEW for
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082     1993