RE: LF on 2 files with 'UNION'

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

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