RE: LF on 2 files with 'UNION'

At 13:34 11/06/2002, Sudha Ramanujan wrote:

I did something like the following that errored out.

 create view filevew  as
  select afield1,afield2,afield3 from filea
   union select bfileld1,bfield2,bfield3 from fileb

Sudha,

Try something like this:

  create view filevew as
    select afield1 field1,
           afield2 field2,
           afield3 field3
    from filea
    union select
           bfield1 field1,
           bfield2 field2,
           bfield3 field3
    from fileb


Pete Hall
pbhall@ameritech.net
http://www.ameritech.net/users/pbhall/index.html