[GENERAL] How to append tables in a view

[Ashish Karalkar]

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