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