Ashish Karalkar wrote: > Hello List, > > I want to append column of two different tables in a single column of a view . > > data type of tow column of two diffrent tables will be same. > > WHAT I WANT TO DO IS: > > Table 1 > ID DESC > 1 A > 2 B > 3 C > > > > > > Table 2 > ID DESC > 1 D > 2 E > 3 F > > > > View(Table1|| Table 2) > ID_view Desc > > 1 A > 2 B > 3 C > 4 D > 5 E > 6 F > > > > Is there any way???
A union -
SELECT id,desc FROM table1 UNION SELECT id,desc FROM table2;
This will give you
ID_view Desc
1 A 2 B 3 C 1 D 2 E 3 F
If you actually want the id_view column to show 1 through 6 then you will want to generate a sequence that is shown for that column instead of the original id column. Or generate the id_view in the client, such as use the row position in the returned set.
