Combining two tables into a view

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?

Thanks,

Peter
pkane_at_cisco.com Received on Tue Apr 20 1993 - 18:20:28 CEST