Re: How to append tables in a view

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Shoaib Mir <shoaibmir(at)gmail(dot)com>
Subject: Re: How to append tables in a view
Date: 2007-02-13 09:23:43
Message-ID: 45D1839F.3060907@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)magproductions(dot)nl

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2007-02-13 09:24:21 Re: How to append tables in a view
Previous Message Shane Ambler 2007-02-13 09:13:01 Re: Testing embedded SQL in C