X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AE0035354D for ; Wed, 4 May 2005 01:32:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79024-10 for ; Wed, 4 May 2005 04:31:58 +0000 (GMT) Received: from smartmx-01.inode.at (smartmx-01.inode.at [213.229.60.33]) by svr1.postgresql.org (Postfix) with ESMTP id 1426053542 for ; Wed, 4 May 2005 01:31:57 -0300 (ADT) Received: from [81.223.151.66] (port=52881 helo=[192.168.100.33]) by smartmx-01.inode.at with asmtp (Exim 4.34) id 1DTBYC-0003iK-C8 for pgsql-admin@postgresql.org; Wed, 04 May 2005 06:31:56 +0200 From: Johannes Lochmann Organization: i-penta Informationsmanagement GmbH To: pgsql-admin@postgresql.org Subject: Re: How the query please! Date: Wed, 4 May 2005 06:31:47 +0200 User-Agent: KMail/1.8 References: <33995.202.81.37.29.1115107252.squirrel@202.81.37.29> <6.1.2.0.2.20050503080723.03272f48@mail.hightowergroup.com> <33263.202.81.37.29.1115172586.squirrel@202.81.37.29> In-Reply-To: <33263.202.81.37.29.1115172586.squirrel@202.81.37.29> X-message-flag: Please send plain text messages only. Thank =?iso-8859-1?q?you=2E=0A?= MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200505040631.48380.j.lochmann@i-penta.at> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/35 X-Sequence-Number: 17464 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