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??? Looks like a UNION ALL to me. -- Alban Hertroys alban@xxxxxxxxxxxxxxxxx magproductions b.v. T: ++31(0)534346874 F: ++31(0)534346876 M: I: www.magproductions.nl A: Postbus 416 7500 AK Enschede // Integrate Your World //