Skip site navigation (1) Skip section navigation (2)

Re: How the query please!

From: "Richard Sitompul" <richard(at)orbisindonesia(dot)com>
To: "David A(dot) Leedom" <daleedom(at)hightowergroup(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How the query please!
Date: 2005-05-04 02:09:46
Message-ID: 33263.202.81.37.29.1115172586.squirrel@202.81.37.29 (view raw or flat)
Thread:
Lists: pgsql-admin
Sorry if you not understand what i mean :D
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). Any body can help me again?


Best Regards,

Richard Sitompul


> Richard,
>
> I am not sure if I really understand your question, but.....
>
> I think what you want is:
>
> "select part_number, product_name from table_product"
>
> Again I am not sure if I understand what you are really looking for so if
> this is not it ask again.
>
> Enthusiastically,
>
> Dave Leedom
>
> At 04:00 AM 5/3/2005, Richard Sitompul wrote:
>>Hi folks
>>Any body can help me?
>>I have six table_product, in @ table_product have field part_number and
>>product_name, I want to get the part_number and the product_name from
>> the
>>six table_product. How the query to get the field part_number and the
>>product_name?
>>
>>
>>Best Regards,
>>
>>Richard Sitompul
>>
>>
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>
>
>
> The Hightower Group, Inc.
> Custom Software Solutions Designed To Fit Your Business Like A Glove.
> 165 West Airport Road, Suite B/Lititz, PA 17543
> V:717-560-4002, 877-560-4002 x: 114
> F:717-560-2825
> www.hightowergroup.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>



In response to

Responses

pgsql-admin by date

Next:From: Christopher BrowneDate: 2005-05-04 03:52:12
Subject: Re: REMOVE
Previous:From: Enrico WeigeltDate: 2005-05-04 01:55:58
Subject: ODBC + pgsql on win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group