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
