Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 927D99FB84B for ; Thu, 22 Mar 2007 16:46:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 54429-02 for ; Thu, 22 Mar 2007 16:46:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from correio2.docasdoporto.com.br (8.144.199.200.docasdoporto.com.br [200.199.144.8]) by postgresql.org (Postfix) with ESMTP id 2DF5A9FB58D for ; Thu, 22 Mar 2007 16:46:35 -0300 (ADT) Received: from [201.30.172.2] (account ezequias@fastcon.com.br HELO [192.168.0.110]) by correio2.docasdoporto.com.br (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 47126587 for pgsql-sql@postgresql.org; Thu, 22 Mar 2007 17:03:50 -0300 Message-ID: <4602DC7A.60506@fastcon.com.br> Date: Thu, 22 Mar 2007 16:43:54 -0300 From: "Ezequias R. da Rocha" User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Dummy question Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/302 X-Sequence-Number: 27940 Hi list, I must use a select * from some table but i must do a join and it must be in the were clause. I can't put select * from tabel1 as tb1, table2 as tb2 where tb2.id = 2 and tb1.fk_tb2ID = tb2.id I don't would like to use this select statement because the select brings us both columns (all columns) of both tables. ps: I don't want to put all fields names too. Can someone tell me if there is any way to put on the select only the fields of my first table ? Regards... -- Atenciosamente Ezequias Rodrigues da Rocha