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 B489F535D6 for ; Tue, 3 May 2005 09:03:08 -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 16365-05 for ; Tue, 3 May 2005 12:03:05 +0000 (GMT) Received: from hightowergroup.com (mail005.readyhosting.com [63.99.209.11]) by svr1.postgresql.org (Postfix) with ESMTP id 8D9C753485 for ; Tue, 3 May 2005 09:03:04 -0300 (ADT) Received: from hightower10.mail.hightowergroup.com [66.109.231.196] by hightowergroup.com with ESMTP (SMTPD32-8.05) id A8316740140; Tue, 03 May 2005 07:01:53 -0500 Message-Id: <6.1.2.0.2.20050503080723.03272f48@mail.hightowergroup.com> X-Sender: dleedom@hightowergroup.com@mail.hightowergroup.com X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Tue, 03 May 2005 08:07:40 -0400 To: "Richard Sitompul" , pgsql-admin@postgresql.org From: "David A. Leedom" Subject: Re: How the query please! In-Reply-To: <33995.202.81.37.29.1115107252.squirrel@202.81.37.29> References: <33995.202.81.37.29.1115107252.squirrel@202.81.37.29> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.887 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200505/17 X-Sequence-Number: 17446 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