Re: combining rows from 2 tables
From: jt <judiphuongtu_at_yahoo.com>
Date: 18 Sep 2003 09:34:24 -0700
Message-ID: <6f38222f.0309180834.207b3fa5_at_posting.google.com>
Date: 18 Sep 2003 09:34:24 -0700
Message-ID: <6f38222f.0309180834.207b3fa5_at_posting.google.com>
osy45 <member18536_at_dbforums.com> wrote in message news:<3384307.1063861534_at_dbforums.com>...
> create view <view> (col1, ... col<n>) as
>
> select col1, ... col<n> from tab1
>
> union
>
> select col1, ... col<n> from tab2
>
> /
Thanks everyone.
-Judi Received on Thu Sep 18 2003 - 18:34:24 CEST