Re: How the query please! - Mailing list 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