I guess UNION ALL should work good here instead of a UNION for the exact same kind of output he needs:
SELECT id,desc FROM table1 UNION ALL SELECT id,desc FROM table2; ---+--- 1 | A 2 | B 3 | C 1 | D 2 | E 3 | F As UNION gave me a little different output, like this: ---+-- 1 | A 1 | D 2 | B 2 | E 3 | C 3 | F -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 2/13/07, Shane Ambler <[EMAIL PROTECTED]> wrote:
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. -- Shane Ambler [EMAIL PROTECTED] Get Sheeky @ http://Sheeky.Biz