Re: How the query please!

Поиск
Список
Период
Сортировка
От Johannes Lochmann
Тема Re: How the query please!
Дата
Msg-id 200505040631.48380.j.lochmann@i-penta.at
обсуждение исходный текст
Ответ на Re: How the query please!  ("Richard Sitompul" <richard@orbisindonesia.com>)
Ответы Re: How the query please!  ("Richard Sitompul" <richard@orbisindonesia.com>)
Список pgsql-admin
On Wednesday 04 May 2005 04:09, Richard Sitompul wrote:

Hello Richard!

> I have six table_product, for example :
> table_product_1
> table_product_2
> table_product_3
> table_product_4
> table_product_5
> table_product_6
>
> in table_product_1 until table_product_6 have field part_number and
> product_name. I want to ask here, how the query to get the part_number and
> product_name in one view(product_view).

hm. are you searching for something like this, perhaps?

create view product_view
as
select
    part_number
    ,product_name
from table_product_1

union

select
    part_number
    ,product_name
from table_product_2

union

...

> Any body can help me again?

Is it this what you where searching for?

HAND && HTH

Johannes

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Lipy Reis"
Дата:
Сообщение: Postgre 8.0 for Linux i586
Следующее
От: "Richard Sitompul"
Дата:
Сообщение: Re: How the query please!