How to append tables in a view

["Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx>]

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???

 

Thanks in advance

Ashish...