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 <pgsql@xxxxxxxxxxxxxxxx> 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
pgSQL@xxxxxxxxxxxxxxxx
Get Sheeky @ http://Sheeky.Biz
