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 23F75537CE for ; Tue, 3 May 2005 23:10:18 -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 57395-07 for ; Wed, 4 May 2005 02:10:09 +0000 (GMT) Received: from mx2.net2cyber.net (unknown [202.43.166.61]) by svr1.postgresql.org (Postfix) with ESMTP id 38EA5537C6 for ; Tue, 3 May 2005 23:10:04 -0300 (ADT) Received: from goliath.3wsi.net (unknown [202.43.166.77]) by mx2.net2cyber.net (Postfix) with SMTP id ACD4459E61 for ; Wed, 4 May 2005 09:17:36 +0700 (WIT) Received: (qmail 26001 invoked by uid 1026); 4 May 2005 02:09:40 -0000 Received: from richard@orbisindonesia.com by goliath.3wsi.net by uid 64011 with qmail-scanner-1.22 (sophie: 3.04/2.28/3.90. spamassassin: 2.60. Clear:RC:1(202.81.37.24):. Processed in 0.192271 secs); 04 May 2005 02:09:40 -0000 Received: from unknown (HELO vas.3wsi.net) (202.81.37.24) by 0 with SMTP; 4 May 2005 02:09:39 -0000 Received: (qmail 5912 invoked from network); 4 May 2005 02:09:46 -0000 Received: from unknown (HELO webmail.orbisindonesia.com) (202.81.37.24) by 0 with SMTP; 4 May 2005 02:09:46 -0000 Received: from 202.81.37.29 (SquirrelMail authenticated user richard@orbisindonesia.com); by webmail.orbisindonesia.com with HTTP; Wed, 4 May 2005 09:09:46 +0700 (WIT) Message-ID: <33263.202.81.37.29.1115172586.squirrel@202.81.37.29> In-Reply-To: <6.1.2.0.2.20050503080723.03272f48@mail.hightowergroup.com> References: <33995.202.81.37.29.1115107252.squirrel@202.81.37.29> <6.1.2.0.2.20050503080723.03272f48@mail.hightowergroup.com> Date: Wed, 4 May 2005 09:09:46 +0700 (WIT) Subject: Re: How the query please! From: "Richard Sitompul" To: "David A. Leedom" Cc: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.3a X-Mailer: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/33 X-Sequence-Number: 17462 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 >