You most certainly can!
create view new_names (name1, name2, name3) as
select * from table...
In article <5ktvpc$ddd@cssun.mathcs.emory.edu>,
dhinkle@firstam.com wrote:
>Hey folks,
>
>Is there a way to create a view on a group of tables that have
>identical col. names? The tables contain data from the 4
quarters of
>the year, ie:
<snip>
----------------------
Rudy Fernandes
GIC, Kuwait
OL 7.20, 4Gl 6.04
----------------------